using Dim function

[agiammo]

I have a general question. I have a nice bit of code (thank you Nate!) that uses two dims. I've been able to plug this into various macros with no problems.

Previously, I have used it in a macro that opens up four different workbooks and uses the exact same code in each.

Currently, I'm working on a macro where I wanted to use this code twice in the same workbook, but on different sheets. I was given a 'duplicate' error message. Ok, so I figured out all I need to do is change the letter.

But my XL book sucks. It doesn't explain how these dims really operate. Does anyone have a good resource to share? I'd like to read more about this function so I really understand what I'm doing with it.

THANKS!

 

[lenze]

The VBA Help file "Declaring Variables" is fairly complete

 

[Andrew Poulsom]

Dim declares variables and allocates storage space. It is short for Dimension, which, in old versions of basic, was used to declare the dimensions of an array. For more information search for Dim in VBE Help.

You can declare a variable only once within a procedure or at the top of a module, but you can use it more than once by assigning a different value to it.