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

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

I have used the phrase "Range("a1").CurrentRegion". It sounds like that
might be what you are looking for.

"ExcelMonkey" wrote:

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

Maybe what you are looking for is "Range("A1").CurrentRegion". Of course you
can change the address of the range for which you are looking.

"ExcelMonkey" wrote:

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

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

Same question, just non-contiguous.

--
HTH

Bob

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

"ExcelMonkey" wrote in message
...
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