Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command to jump to last row in list not working
I usually go to the bottom of the column and move up using
xlup and offset try this code Range("B65536").Select ActiveCell.End(xlUp).Offset(1, 0).Select -----Original 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 . |
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) | |||
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 | |||
Command to jump to last row in list not working | Excel Programming |