Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need macro to move to first blank cell in column
Hi. I am trying to use a macro to move from A1 to the first blank cell in col
A. There are no gaps in the data. When the first blank cell is selected, data will be copied and pasted from another worksheet. Then the adjacent cell in col B must be selected and again data will be copied and pasted there from another worksheet. Finally, the adjacent cell in col C must be selected but the formula from the cell above must be extended down one cell. I have recorded a macro which does all this but the problem is that when I repeat the macro the same row is always selected instead of the next blank one. Here are the steps I did while recording the macro: 1 .Select & copy A1 2.Press <cntl + <end (this brings me to last filled cell in col C) 3. Press down arrow key 1 time and left arrow key 2 times to move to 1st blank cell in col A. 4. Paste in col A blank cell 5. Copy cell from other worksheet (always the same cell #) 6. Select original worksheet. Press right arrow key once to move to col B. 7. Paste in col B blank cell 8. Press right arrow once and up arrow once to move to last filled cell in col C. 9. Extend the formula down one cell in col C. Now the previous 3 blank cells in col A, B & C are filled. But when I repeat the macro the same cells are filled, not one down each time. Can someone help? Thanks, Joe M. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to delete rows if cell blank in column | Excel Discussion (Misc queries) | |||
Macro to delete blank rows and move data/info | Excel Discussion (Misc queries) | |||
Move Column within Sheet with VB Macro | Excel Discussion (Misc queries) | |||
Macro to go to next blank cell in column | Excel Discussion (Misc queries) | |||
Macro to move to next column | Excel Discussion (Misc queries) |