Problem with Syntax

[andygame]

Hi all . . . . newbie here again

I'm trying to select several cells in a row (non - adjacent). Seemingly very simple and easy when I analysed a recorded macro sequence.

However, when I substitute the row number for a variable (MenuRow) I don't seem to be able to get the syntax right. Any help appreciated.

So for example if I want to select A4, F4 and H4 (where MenuRow = 4) I tried the following

Range ("A" & MenuRow), ("F" & MenuRow), ("H" & MenuRow).select (and about a thousand other variations!)

I don't even know if I can do this with the Range statement. Please help.

 

[Fluff]

How about

   Range("A" & MenuRow & ",F" & MenuRow & ",H" & MenuRow).Select

 

[mikerickson]

Rows(MenuRow).Range("A1, F1, H1").Select

 

[andygame]

How about

   Range("A" & MenuRow & ",F" & MenuRow & ",H" & MenuRow).Select

Perfect Fluff - Exactly what I needed - many thanks.

 

[Fluff]

Glad we could help & thanks for the feedback.