Il giorno lunedì 31 luglio 2017 10:41:29 UTC+2, Claus Busch ha scritto:
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

Thanks Claus,
but they are vba variables not cells.

Bye