Tips and tricks

16 January 2009

Excel VBA – declaring multiple variables

Did you know...

If you type

DefInt I-N

in the declaration section at the top of a module, then you can use variables i j k l m and n anywhere in the module without defining them again.

Great for loops!

 

 

Posted by Maggie Hill