Thread: Sequential variables (no array)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Sequential variables (no array)
Hi,

Am Mon, 31 Jul 2017 01:35:55 -0700 (PDT) schrieb :

aa1 = 9
aa2 = 9
aa3 = 9
......
aa100 = 9

you don't need a loop.
Try:
Range("AA1:AA100")=9


Regards
Claus B.
--
Windows10
Office 2016
Reply With QuoteReply With Quote