Hi Joel & Tom
I'm using both your suggestions now.
Many thanks
Don
--
donwb


"Tom Ogilvy" wrote:

If the block started in cell A1, then

Range("A1").CurrentRegion.Select

would be what I would try.

If you region is bounded by at least one truly emtpy row and column on the
sides (0r the borders of the sheet), then that should work.

--
Regards,
Tom Ogilvy


"donbowyer" wrote:

Excel 2003 on XP

I have a worksheet containing one contiguous block of cells containing data,
which I wish to select.
If I use ActiveSheet.UsedRange.Select it often selects a range greater
than the block of cells - ie includes cells apparently containing no data.
What am I doing wrong?

--
donwb