Range Selection Not Working

**timbo1957** · 11-04-2011, 12:16 PM

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** · 11-04-2011, 03:43 PM

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** · 11-04-2011, 04:27 PM

Please Login or Register  to view this content.

**timbo1957** · 11-08-2011, 09:38 AM

Thanks guys a great help.

Re: Range Selection Not Working