VBA Syntax

[normpam]

Range("E2, G2").Select (This is what I want to do, but without specific cell addresses)

Range (ActiveCell), Range(ActiveCell).Offset(0, 3).Select

What syntax can I use to do this?

(hope this makes sense!)

 

[Fluff]

Try

ActiveCell.Resize(1,4).Select

 

[Joe4]

One way:

Range(ActiveCell, ActiveCell.Offset(0, 3)).Select

 

[normpam]

Try

ActiveCell.Resize(1,4).Select

Thanks for the quick reply. What I will need is to run this through in a loop, so I think I will need to use the Range and offset. Does that make sense?

 

[normpam]

One way:

Range(ActiveCell, ActiveCell.Offset(0, 3)).Select

Thanks Joe, but that selects the cells in between. I need only the two non-adjacent cells.

 

[Fluff]

How about

Union(ActiveCell, ActiveCell.Offset(, 3)).Select

 

[Joe4]

Thanks Joe, but that selects the cells in between. I need only the two non-adjacent cells.

Sorry, that wasn't very clear in your question.
Try this:

    Dim rng As String
    rng = ActiveCell.Address & ", " & ActiveCell.Offset(0, 3).Address
    Range(rng).Select

 

[normpam]

Range("E2, G2").Select (This is what I want to do, but without specific cell addresses)

Range (ActiveCell), Range(ActiveCell).Offset(0, 3).Select

What syntax can I use to do this?

(hope this makes sense!)

I just tried using Union and it works!