Expand selection to add column to the right

I know this has to be simple but I can't seem to find it. I have a macro that does other things that I need it to and I am happy with the steps it does. What I need is a step at the begining that expands the selection from the selected column to include that column and the one to the right. The problem is that the column that will be selected originally is not known, it will initially be selected by the user, at which point the macro will be executed. So for example if they select column G and then run the macro, I need it to select column G and column H. I was able to find a command that used offset to move the active selection one column to the right but I need it to also keep the original column selected.

Hello MnMShow,

Use the Resize method to expand it.

Please Login or Register  to view this content.

Originally Posted by Leith Ross

Hello MnMShow,

Use the Resize method to expand it.

Please Login or Register  to view this content.

I selected a single column at random and ran this macros and I got "compile error: syntax error" with this. This is the only line of code in my script for testing purposes. Can you double check the syntax?

Ahh I figured it out. Added the .select to the end of your command and it does precisely what I wanted. Thanks so much for your help and thanks for responding so quickly.

Hello MnMShow,

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save