Trying to set cell value using macro

[Tushar]

Hello,

I am trying to set the value of a cell to 1 using the Autpen Macro.
the problem is that the cell i am trying to set the value to is a
list. The cell is set as a list box using the data - validation
-allow : list method. I am not sure how to go about setting the value
of this cell to 1 everytime the excel spreadsheet is opened.

Any help is greatly appreciated.

Thanks
Tushar

 

[Frank Kabel]

Hi
why not simply use

worksheets("sheet1").range("A1").value=1

 

[Tushar]

Thanks Frank. That worked like a charm man

Hi
why not simply use

worksheets("sheet1").range("A1").value=1