I am trying to write a macro that will copy 3 columns into a new sheet. Once
this is done and I have run the other part of my macro I want it to go back
and copy another 3 columns. I always want to copy column "A" each time. The
1st time I want "A,B,C" then columns "A,D,E". "A,F,G" etc.

Currently I have:

Sheets("SBS Graphs - Main").Select
Range("A:A, B:B, C:C").Select
Range("C1").Activate
Selection.Copy
Sheets("Test").Select
Range("A1").Select
ActiveSheet.Paste

<remaining macro

which I have been copying.

How do I get the macro so it changes the column reference for the last 2?

Thanks