Thread: Excel VBA-How do I increment columns in VBA?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
  
Posts: 11,272
Default Excel VBA-How do I increment columns in VBA?
For i = 1 To 4
Columns(i).Select
Next i

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"waveracerr " wrote in message
...
I want to run a macro that cycles through columns within a For loop. I
can do this within a range no problem. How to do it in columns
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!

Ryan


---
Message posted from http://www.ExcelForum.com/



Reply With QuoteReply With Quote