select multiple cells
 

Hi All
How do I select multiple cells using macro.
I tried the following and it selects only the last cell

starta.Offset(i, j).Select
starta.Offset(i + 1, j).Select
starta.Offset(i + 2, j).Select

Tell me how can i correct this macro code.

Thanks

Shanu

select multiple cells
 

On Nov 6, 11:28 am, sharmashanu wrote:
Hi All
How do I select multiple cells using macro.
I tried the following and it selects only the last cell

starta.Offset(i, j).Select
starta.Offset(i + 1, j).Select
starta.Offset(i + 2, j).Select

Tell me how can i correct this macro code.

Thanks

Shanu

Range("A1:D12").select

meg99

select multiple cells
 

For any three cells you can always use UNION()

UNION(starta.Offset(i, j), starta.Offset(i + 1, j), starta.Offset(i + 2,
j)).Select

--
Gary''s Student - gsnu2007a


"sharmashanu" wrote:

Hi All
How do I select multiple cells using macro.
I tried the following and it selects only the last cell

starta.Offset(i, j).Select
starta.Offset(i + 1, j).Select
starta.Offset(i + 2, j).Select

Tell me how can i correct this macro code.

Thanks

Shanu

select multiple cells
 

Hi Gary
It worked thanks. Thanks for teaching me new function.

Shanu