MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Incrementing the active cell between iterations

Posted by SWallace on December 12, 2001 8:36 AM

Hi Newbie here , I've looked back through your
Posts and found lots of answers ,Thanks. What I'd like to do is increment the active cell right ( start at A then B etc ) at the end of a piece of code
Basically after the link is pasted I want to
paste my nextfile's data into the next column
and so on .Any suggestions would be great Thanks!

piece of code I'm Working with !!

For i = 1 To FileCount
Workbooks.Open File(i)
ActiveSheet.Paste Link:=True

Next i

Posted by Dan on December 12, 2001 9:24 AM

Not sure if I completely understand, but I think you are looking for the command

Selection.Offset(0, 1).Select

Which will move the current selected range over 1 column. Let me know if this isn't what you are looking for.