Selecting Contiguous Ranges on a Sheet

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

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)
 
I have used the phrase "Range("a1").CurrentRegion". It sounds like that
might be what you are looking for.
 
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.
 
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
 
Same question, just non-contiguous.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy .Areas.Item(1,2,3,4,5, etc.) to a column or a row 5
How do I change the active cell in a non contiguous range or selection? 0
Looping through Non contiguous cells in a row 11
ActiveCell on inactive sheet 8
Print Non-Contiguous Ranges From User Input on All Worksheets 4
Selecting more than 1 named range 2
Finding Smallest Date in Non Contiguous Range 3
select uneven range 2

Back
Top