Thread: Excel VBA - changing variables during a loop
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ellis_x[_3_] ellis_x[_3_] is offline
external usenet poster
  
Posts: 1
Default Excel VBA - changing variables during a loop
Hi,

I am trying to write a loop code using the For...Next statements, for
counter running from 1 To 100. However, I want to change the value o
two of the variables (there are 5 used in the procedure) after counte
= 10, then again at 20, 30, and so on.

I have not been able to figure out how to do this without repeating th
code with the new value for the variable re-defined.

Has anyone got any ideas of how to overcome this problem?

Cheer

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

Reply With QuoteReply With Quote