Sorry Bob, I was vague. I want the ability to select all the non-contiguous
ranges on a worksheet. I said contiguous by accident. I seem to remember
that this is actually very easy to do. I just cant remember how to do it.

Thanks

EM

"Bob Phillips" wrote:

What are you meaning when you say the contiguous ranges?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"ExcelMonkey" wrote in message
...
How do you select the contiguous rangs in a spreadsheet? I seem to
remeber
that you can select the entire sheet by going:

Cells().Select

I know Cells() has an Area property but
Cells().Areas.Select

does not work.

Thanks

EM