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 . |
All times are GMT +1. The time now is 04:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com