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)
Sheets("totals").Select
Range("B14:B16").Select
Selection.Copy
Windows("Calculator.xls").Activate
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.