Copy and Paste Different Column Macro

[shutupx]

I'm new here in this site but it was informative nevertheless.

i have different columns with different values in it. for example
A B C
1 7 20
2 8 21
3 9 22
4 10 23

my question is. is there a possibility to copy column A then Column b then column c to another sheet continuously.

Here's what i got so far.

Dim iter As Integer
For iter = A To B
Sheets("Sheet2").Range("B1:B50").Copy
Sheets("Sheet1").Range("A5").PasteSpecial
Next

I was thinking that the iter can replace the range or something but unfortunately it didn't work.
thank you in advance and god bless.

 

[texasalynn]

Welcome to MrExcel board...

not sure I follow your objective for copying one column at a time to other sheet.

Here is the code to do that

Dim LC As Long
'
LC = Range("IV1").End(xlToLeft).Column
For i = 1 To LC
    Columns(i).Copy
    Sheets("Sheet3").Activate
    Columns(i).Select
    ActiveSheet.Paste
    Application.CutCopyMode = False
    Sheets("Sheet1").Activate
Next i

if you will explain what you are wanting the and results, there is probably a faster cleaner approach