Search MACRO to select without knowing the range !

[Jchicoine]

Hi everyone !

I've search previous postings and I've found nothing yet. I need a macro to select a few cells without knowing in advance which range it will be.

Ex: If my active cell is on range 3, I want to select D3,E3 and G3.
If my active cell in on range 5, I want to select D5, E5 and E5.

Thanks a lot everybody !

[Tom Schreiner]

What is range 3, 5?
Tom

[Jay Petrulis]

You want to select, D,E, and G of the active row, correct?

If so, try,
-------------------
Sub tester()
Dim x As Long

x = ActiveCell.Row
Range("D" & x & ",E" & x & ",G" & x).Select

End Sub
-------------------

HTH,
Jay

[Tinhare]

On 2002-04-30 08:36, Jchicoine wrote:
Hi everyone !

I've search previous postings and I've found nothing yet. I need a macro to select a few cells without knowing in advance which range it will be.

Ex: If my active cell is on range 3, I want to select D3,E3 and G3.
If my active cell in on range 5, I want to select D5, E5 and E5.

Thanks a lot everybody !

What is the difference between range 3 and 5.
Also do you mean D3,E3, G3 for range 2 and D5,E5,(E5 or G5) for range 5.

Cheers,
Alan

[Jchicoine]

Thanks a lot Jay Petrulis !

Sorry I didn't explain my problem right but you gave me the answer I need.

Thanks again !

[waderw]

You could also try the "xlspecialcells" function.