Evaluating cell content and then doing one of two things.
Posted by Jay on February 08, 2002 11:03 AM
Hi
I am trying to look at B2 and if any information is there or number or data then move over to the right one cell and up one cell and copy active cell and move back down one cell and paste move over one cell and up and copy and down and paste. When I copy and paste I want the A2 in formula to change to A3 or A4 or A5 etc. as I continue to copy and move down in my worksheet. If I copy by hand with the mouse and paste down the A2 will change to A3 and so forth. What can I do to make it change. Hope you understand all if this. Thanks Jay
Posted by Jacob on February 08, 2002 1:58 PM
Hi
You can do something like this
For x = 1 to range("A65536").end(xlup).row
if range("A" & x).value = "" then
else
range("A" & x).offset(-1,1).copy
etc etc
HTH
Jacob
