select multiple cells

S

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
 
M

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("A1:D12").select

meg99
 
G

Gary''s Student

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top