VBA Single-Lettered Variables

[Vathana]

Hello all.

Weird question? But is it safe to name variables with one letter only (A to Z)? I've seen "I" and "J" often in examples on the webs and used those myself too, but I'm afraid ones of the letters are VBA keywords.

Thanks.

 

[Vathana]

Yeah same here. I've always wondered why "I" and "J" are used so often in loops

 

[Fluff]

My guess is that i was originally just short for integer & if you needed a 2nd loop you just used the next letter. ?‍
I usually i for the counter unless It's for a 2D array in which case i use r & c.

 

[B___P]

Single letter variables can make debug difficult. Multiletter variables can use camelcase so at coding time you have a prompt feedback about what you are writing.