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 -- there is already data in this cell-- I would like to change which cell is selected to be the cell just to the right, or B9 -- there is no data in this cell yet)?
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 -- there is already data in this cell-- I would like to change which cell is selected to be the cell just to the right, or B9 -- there is no data in this cell yet)?
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.
