View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JDM JDM is offline
external usenet poster
 
Posts: 7
Default Changing Column Reference in Macros?

I want to write a macro that will move to the next column each time I run it.
Below is what I have from a recording. I need to change the "AC:AC" to
"AD:AD" next time I run this macro, same for the AD below that. I can create
a table in my worksheets that will always have the new column to point to,
but I don't know how to reference it in my macro.

ActiveWindow.SmallScroll Down:=-16
Sheets(Array("Deposits", "Rates")).Select
Sheets("Deposits").Activate
Columns("AC:AC").Select
Application.CutCopyMode = False
Selection.Copy
Columns("AD:AD").Select
Selection.Insert Shift:=xlToRight
Columns("AC:AC").Select