What is Dim?

[DamienC]

Hi guys,

I have been using the four lines below in macros. They were part of one of the macros royUK helped me with. I keep using them, but I have no idea what it means.

Can somebody tell me what I am actually telling the macro? I think it would help me greatly in expanding my understanding of macros.

Dim cl As Range
Dim rng As Range
Dim R As Long
Dim X As Long

The help is enormously appreciated. I am learning more every day.

[StephenR]

Not to be unhelpful but you could look all this up in VBA Help. Basically you're 'declaring' that these variables represent a range (of cells) or an integer between certain set values (can't remember the limits offhand). It's good practice to do this.

[royUK]

See if this helps

http://www.excel-it.com/clear_code.htm

Also, if you highlight a word in the VB Editor & press F1 then the relevant help file will open