Selecting/Deselecting

[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!

 

[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.

 

[Frank Kabel]

Hi
in VBA try soemthing like
activesheet.range("A1:B300").select

 

[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)