View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad Patterson Brad Patterson is offline
external usenet poster
 
Posts: 16
Default How to: reset the pull down menus to item 1 on start up?

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?