View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hotherps[_32_] hotherps[_32_] is offline
external usenet poster
 
Posts: 1
Default Loop through ranges columns

I'm using a For next loop to determine the number of rows and columns m
code should run in.

What If I have multiple ranges of columns that need to be ru
indepenedently. Let's say A:K then L:R then S:Z with the rows at
constant of 1 to 100

For Each Cell in Range ("A:K") ??How do I state the next range?

Does there need to be a Loop at the bottom of the code?


Thanks:confused

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