select multiple cells

[sharmashanu]

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

 

[meg99]

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("A112").select

meg99

 

[Guest]

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

 

[sharmashanu]

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

Shanu