Selecting Contiguous Ranges on a Sheet
 

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

Selecting Contiguous Ranges on a Sheet
 

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

Selecting Contiguous Ranges on a Sheet
 

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

Selecting Contiguous Ranges on a Sheet
 

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

Selecting Contiguous Ranges on a Sheet
 

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

Selecting Contiguous Ranges on a Sheet
 

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