How to: reset the pull down menus to item 1 on start up?
How to: reset the pull down menus to item 1 on start up?Hi Brad
Range("b1,b3,b5,b7").value=1
will do the job.
--
Best Regards
Leo Heuser
MVP Excel
Followup to newsgroup only, please.
"Brad Patterson" skrev i en meddelelse
...
Okay, I can do the following ...
Range("B1").value = 1
Range("B3").value = 1
Range("B5").value = 1
Range("B7").value = 1
- is there an easier way to make all those values = 1?
|