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
.