variables in row and cell functions
 

Curious how you get them to recognize them.

Ex. code

n = 1

do until n 25
Rows("n:n").select
If "ect ect ect"
n = n + 1
loop


It always highlights the ("n:n")in yellow and wont work
properly.

variables in row and cell functions
 

n = 1

do until n 25
Rows(n).select
If "ect ect ect"
n = n + 1
loop


or as an example using Cells

n = 1

do until n 25
Cells(n,1).EntireRow.select
If "ect ect ect"
n = n + 1
loop

--
Regards,
Tom Ogilvy

"zeraia" wrote in message
...
Curious how you get them to recognize them.

Ex. code

n = 1

do until n 25
Rows("n:n").select
If "ect ect ect"
n = n + 1
loop


It always highlights the ("n:n")in yellow and wont work
properly.