Looping through columns

[Mick]

Hi

Want to use the isEmpty function to examine cells dependent on column
(e.g. B1, C1, D1)

If B1 has data in it then insert data into C1 etc. Doing this with
rows is easy by substituting the row number with a variable (x) so

range("sheet1!a & x")

How do I substitute the column reference? Do i need to use R1C1
referencing?

Thanks

Mick

 

[Conan Kelly]

Mick,

You can use Cellls(RowNbr,ColumnNbr) in place of Range(). So...

Cells(1,1) is A1
Cells(1,2) is B1
Cells(2,1) is A2

....then substitute variables for both rows and columns. Maybe something
like "plngRow" and "plngColumn":

Cells(plngRow,plngColumn)

HTH,

Conan