7590doylem
New Member
- Joined
- Feb 28, 2011
- Messages
- 4
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.
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.
