View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
waveracerr[_4_] waveracerr[_4_] is offline
external usenet poster
 
Posts: 1
Default Excel VBA-How do I increment columns in VBA?

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/