hi,

i have the following:
Range("A5000").End(xlUp).Offset(0, 0).Select

the only problem is this is being run when the sheet is in Autofilter mode.
I want the range to be selected, except for the header row. How can i modify
this?

thanks in advance,
geebee