For each loop

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

How do I create a "for each" loop on each row to check
if a cell is empty and then copy it to another cell on
same row? I am having trouble refering to a column.
 
something like where you want to copy the NON empty cell 2 cells to the
right.

x=cells(rows.count,activecell.column)
for each c in
range(cells(2,activecell.column),cells(cells(x,activecell.column))
if c<>"" then c.offset(0,2).value=c
next
 
Thank you for your response, but I cannot get it to
work. I put in the last closed parenthesis, still no.
Any suggestions?
 
Back
Top