Is there a way to increment the column with vba code. I need to move A1 to B1 to whatever a variable is.

Thanks and any help will be greatly appriciated.

Steve