ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Active cells (https://www.excelbanter.com/excel-programming/315807-active-cells.html)

nd714

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

Bob Phillips[_6_]

Active cells
 
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?




Bernie Deitrick

Active cells
 
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?




Dan Thompson

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

"nd714" wrote:

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



All times are GMT +1. The time now is 10:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com