Not really, I just don't want any rows after my data finishes, so that when I
do a pivot table bassed on column A:D it doesn't bringing in the very
annoying (Blank) column. Doing this through VB with a changing amount of data
so have to select the columns instead of range of data.

Thanks........ Alastair.

"Zack Barresse" wrote:

Hi Alastair79,

If you use AutoFilter and filter for blank rows, you can then select your
data, press F5 | special | blank cells | Ctrl + - (minus) | Entire row | Ok.

Is this what you're looking for?

--
Regards,
Zack Barresse, aka firefytr (MVP: Excel)


"Alastair79" wrote in message
...
Is it possiable to shorten a worksheet to that it doesn't empty rows after
your Data has finished. I don't want to hide them but remove them
altogether!!

Thanks.......... Alastair.