Cannot understand the meaning of a couple of variables

[rasmus1166]

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!!

[Andrew-R]

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.

[rasmus1166]

Think I got it :P

Thanks Andrew!!

[snb]

You can colour a row in 1 go:

Please Login or Register  to view this content.

[rasmus1166]

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

[snb]

In/from VBEditor's (Alt-F11) helpfiles (F1).