Selecting cells in next/previous column depending on current selected cells

[Skeidser]

Hello.

My current code is this:

Please Login or Register  to view this content.

If I have values in fx G1, 2, 3 & 4, then the first line of the code will select G1:G4.
I want the second line to select F1, 2, 3 & 4 as well. But as it is now, it will instead select F1 and G1. I see how the ActiveCell is the problem, since no matter the amount of selected cells, only one will be the active one.

Is it possible to have the code select cells in column F dependent on the selected cells in G, and not just the active cell?

Cheers.

[daboho]

Please Login or Register  to view this content.

[Skeidser]

Please Login or Register  to view this content.

That was easy and simple. Thank you so much!

[daboho]

Glad for.help dont forget mark case as solved

[Skeidser]

Glad for.help dont forget mark case as solved

Already done