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.
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.