Hi All,
I am new to writing macros in excel, and I am having trouble writing a macro to merge alternating columns in excel 2010.
My code is below, and a sample worksheet attached. The problem I am having is the macro will only merge the first column offset 1 from the active cell. It will not continue to the 3rd, 5th, etc.
Is there any way I can create a command that increases my offset numbers by a given value, in this case two? I can do this manually, but I am sure there must be a way to do this quickly within VBA.
Thanks for the help!
Best,
Mark
Bookmarks