Cannot understand the meaning of a couple of variables

Can anyone please please explain to me what 'rOld', and 'Dim i' means???

Please Login or Register  to view this content.

Thank you so much!!

rOld is a variable representing a range of cells. It is set if you change a cell which isn't on row 1 and will represent a range of columns 1-256 on the row on which the change is made.

It's declared as a static variable, so its value won't be reset each time the sub-routine is called.

"Dim i As Long" just declares a numeric variable. Programming tradition uses "i" as the variable to control looping through a series of numbers, which is exactly what i is being used for in the line "For i = 1 To cnNUMCOLS", where it will loop from 1 through to 256.

Think I got it :P

Thanks Andrew!!

Could you maybe tell me how/where you learnt this??