New to VBA, need help with For Loop

Hello,

I'm trying to create a program that will move a column from one sheet to another based on the header in the column. Depending on the report that I pull, this column can change location (it will always be the first row) so I tried creating a For Loop to move through the columns but when I run the program, nothing happens. I know it has to do with the For Loop because if I specify the cell that the word "DATE" is in, everything moves just fine. Here's what I have:

Please Login or Register  to view this content.

End Sub

Thanks in advance!

Hi jazzyvba, the For Loop doesn't require you to have the colnum = colnum + 1. Try removing that.