variables in row and cell functions

  • Thread starter Thread starter zeraia
  • Start date Start date
Z

zeraia

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.
 
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
 
Back
Top