VBA Positioning Code

[7590doylem]

I'm putting together a macro in Excel 2007 (Windows XP) to paste some data in a cell range that feeds a graph.

Is there a vba code that will change what cell is selected one column to the right (Example: Current Selected cell is A9, I would like the selected cell to be one to the right, or B9)

My desired selected-cell will always be changing (as I add more data, the desired selected-cell will move further column(s) to the right, and therefore I cannot give it a specific cell to locate each time)

Ideally, I'd like to start at the same cell each time, and then select the first blank cell to its right.

 

[VoG]

Perhaps

ActiveCell.Offset(, 1).Select

 

[7590doylem]

Thank you, sir. Worked exactly how I wanted it to.