Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
What command do I need to type to move the cursor one cell down? I have
created a macro that copies an entire line of data to a spreadsheet by going to a specific column, using the end and down commands, to find the first empty cell. My problem is that after I have recorded the macro, the cursor never moves down that one cell and keeps copying the data on that same line. I have tried multiple times with it recording what I want, but VBA will not move down to the next empty cell on subsequent runs. Any help would be appreciated. |
#2
![]() |
|||
|
|||
![]()
Wolf, try this, with data in column A
Range("A65536").End(xlUp).Offset(1, 0).Select -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Wolf" wrote in message ... What command do I need to type to move the cursor one cell down? I have created a macro that copies an entire line of data to a spreadsheet by going to a specific column, using the end and down commands, to find the first empty cell. My problem is that after I have recorded the macro, the cursor never moves down that one cell and keeps copying the data on that same line. I have tried multiple times with it recording what I want, but VBA will not move down to the next empty cell on subsequent runs. Any help would be appreciated. |
#3
![]() |
|||
|
|||
![]()
Paul B.
Thank you so much. It worked just fine. I had built a spreadsheet in Quattro Pro and had to switch it to Excel and was going crazy. I really appreciate your help. This forum was just the ticket I needed. Thanks again. "Paul B" wrote: Wolf, try this, with data in column A Range("A65536").End(xlUp).Offset(1, 0).Select -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Wolf" wrote in message ... What command do I need to type to move the cursor one cell down? I have created a macro that copies an entire line of data to a spreadsheet by going to a specific column, using the end and down commands, to find the first empty cell. My problem is that after I have recorded the macro, the cursor never moves down that one cell and keeps copying the data on that same line. I have tried multiple times with it recording what I want, but VBA will not move down to the next empty cell on subsequent runs. Any help would be appreciated. |
#4
![]() |
|||
|
|||
![]()
Wolf, your welcome
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Wolf" wrote in message ... Paul B. Thank you so much. It worked just fine. I had built a spreadsheet in Quattro Pro and had to switch it to Excel and was going crazy. I really appreciate your help. This forum was just the ticket I needed. Thanks again. "Paul B" wrote: Wolf, try this, with data in column A Range("A65536").End(xlUp).Offset(1, 0).Select -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Wolf" wrote in message ... What command do I need to type to move the cursor one cell down? I have created a macro that copies an entire line of data to a spreadsheet by going to a specific column, using the end and down commands, to find the first empty cell. My problem is that after I have recorded the macro, the cursor never moves down that one cell and keeps copying the data on that same line. I have tried multiple times with it recording what I want, but VBA will not move down to the next empty cell on subsequent runs. Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Can you update links between workbooks without them both open? | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Unable to set the active cell from VBA | New Users to Excel | |||
Moving Down a Cell in Macro | Excel Discussion (Misc queries) |