On Apr 14, 2:20*pm, Matthew Dyer wrote:
I'm going from column to column... i don't see what the problem is...

**snip**
My two cents is that the problem isn't really with the way you've
called out the columns.
This is what works for me:

Dim strBookName As String
Dim strSheetName As String

Workbooks.Add (xlWBATWorksheet)

strBookName = ActiveWorkbook.Name
strSheetName = ActiveSheet.Name

Workbooks("Analytics.xlsm").Worksheets("MTD").Colu mns("G").Copy _
Destination:=Workbooks(strBookName).Worksheets(str SheetName).Columns("A")

Cheers,
ABS