Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Moving Down a Cell in Macro
I am Writing a Macro and it takes rows from one sheet and pastes them on
another sheet. I have most of the macro running fine, but it does this repeatedly and I need help getting it to go down to the next line when it is ready to paste the next row. Please Help Me? |
#2
|
|||
|
|||
there are many ways. depnds upon your code statment
range("c1").offset(1,0) will take you to C2 does this hint help you;l Anonymous wrote in message ... I am Writing a Macro and it takes rows from one sheet and pastes them on another sheet. I have most of the macro running fine, but it does this repeatedly and I need help getting it to go down to the next line when it is ready to paste the next row. Please Help Me? |
#3
|
|||
|
|||
Hi
Maybe this will help you http://www.rondebruin.nl/copy1.htm+ -- Regards Ron de Bruin http://www.rondebruin.nl "Anonymous" wrote in message ... I am Writing a Macro and it takes rows from one sheet and pastes them on another sheet. I have most of the macro running fine, but it does this repeatedly and I need help getting it to go down to the next line when it is ready to paste the next row. Please Help Me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Macro for moving sheets | Excel Discussion (Misc queries) | |||
copy a cell value not its function | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) | |||
This one is tricky....Macro to save file as cell value x in di | Excel Discussion (Misc queries) |