How do I make 3 cells active at the same time?

You don't. You can select 3 at one time (Ctlr-click), but only one is
active.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"nd714" wrote in message
...
How do I make 3 cells active at the same time?

You can't. You can modify 3 (or more) cells at a time, but you can't have
them "Active" at the same time.

HTH,
Bernie
MS Excel MVP

"nd714" wrote in message
...
How do I make 3 cells active at the same time?

You could try this
Worksheets("Sheet1").Range("A1:A3").Activate

"nd714" wrote:

How do I make 3 cells active at the same time?