Copy last used column to adjacent empty column

Greetings, I would like some help with VBA/macro code. I need to copy the entirety of the last used column (for example $G:$G) in a worksheet to the adjacent empty column in the same worksheet. The worksheet is currently set up with columns A,B,C are blank, D,E,F are informational and will not change, column G is made of formulas. This last column G is to be copied to the adjacent empty column H. However, the next time the macro would run, column H would copy to column I, and so on. I am a novice at VBA and greatly appreciate the help! Ah, I am using excel 2010.

Hello itwas45and51,

Something like this should work for you:

Please Login or Register  to view this content.

Updated .Copy line:

Please Login or Register  to view this content.