Need to loop through all populated columns

I am not entirely sure what I am doing here, kinda new to VBA for Excel. I have some basics going for me but not sure how to create a loop for the below code. If someone could help me out that would be great, I could use this as a good example for other loops I want to create. Also if someone has a great online resource for basics on creating a loop taht would be a great addition. Thanks.

Below I am looping through columns B:ZZ and using text to columns to change the SQL output from General to Numeric value. This was created using a macro recorder so I am sure there is some bloat. After the loop is completed I am then resizing the columns and bolding the first row of headers.

Please Login or Register  to view this content.