Excel VBA-How do I increment columns in VBA?

W

waveracerr

I want to run a macro that cycles through columns within a For loop.
can do this within a range no problem. How to do it in column
though...I don't know. Any help?

Eg. For i=1 To 4
Range("A" & (i), "BB" & (i)).Select
Next i

How can I have this code cycle through columns? Thanks!

Rya
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA-How do I increment columns in VBA? 2
comparing two columns in vba 2
Find all in vba 5
Problem sorting a range of columns using VBA 1
select range in column, calculate on range plus 3 columns, output inrange plus 7 columns 8
help with VBA program to import and add formatted files to one file 0
Excel VBA help: Text file formatting 19
Range passed to a function - trying to just move through the range 4

Top