Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command to jump to last row in list not working
Hi Paul,
This might give you a jump start it will take you to the next empty cell after the last cell containing data in Column B. Application.Goto Worksheets("Sheet1").Cells(Rows.Count, 2).End(xlUp)(2) Regards, Rocky McKinley "Paul" wrote in message ... Hi, I'm looking for some help with what should be a really simple problem but it's driving me nuts! I've recorded a macro whereby certain text is copied on 1 worksheet and I want it to paste it to the next available row in a different worksheet. Everything looks fine when I record the macro by performing the actions but when I run the macro the text is always pasted into the same row (which was initially the next blank row) If I check the script it is definitely showing the command "Range("B888").Select Selection.End(xlDown).Select" so it is performing. Any help would be much appreciated Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
JUMP TO PART OF A DROP DOWN LIST | Excel Discussion (Misc queries) | |||
One should be able to "jump" over undo command in Excel | Excel Discussion (Misc queries) | |||
Jump to Sheet Dropdown List | Excel Worksheet Functions | |||
How do I create a command button to jump from sheet to sheet in a. | Excel Worksheet Functions | |||
Quick Jump to end of list... | Excel Worksheet Functions |