Selecting/Deselecting

M

Manhar

What is the easiest method by which I can select or
deselect a large portion of a worksheet? Can I specify a
cell range? Can I select a whole sheet and specify
deselect of a range? Kudos, and thanks for your
continued support!
 
A

Andy B

Hi

One way (of many) is to type the range in the name box (to the left of the
formula box). If you type A1:B345 it will select that range.
 
B

Bob Phillips

In Excel, you can
select a cell and then Ctrl-A, selects the whole sheet
click the grey intersect of the columns and row headers, this will select
the whole sheet
select a cell, then hoild the left mouse button down and drag the cursor to
the final cell

You can You can do all these in VBA

Cells.Select 'whole sheet
Range("A1:H100").Select 'a worksheet range
Range("A1").Resize(12,10).Select 'start at A1 and select 10 columns
and 12 rows

Deselection automatically happens when you sleect something else ....

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top