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