Range Selection Not Working

[timbo1957]

Hi,

I am using this in a small macro -

Please Login or Register  to view this content.

The trouble is it isn't selecting all of the column because there are some blank cells with in it. Is there a way around this?

Regards

Tim.

[mojo249]

You could try offsetting and End(xlUp) instead:

Please Login or Register  to view this content.

Note that it will produce an error if the offset takes it beyond the 65536 row limit.

[foxguy]

Please Login or Register  to view this content.

[timbo1957]

Thanks guys a great help.