Code to make cell/ range a specified value

[hannah_sydney]

Hi,

What code do I need to make a specified cell/ range equal a certain value everytime a workbook is opened?

Many thanks!

 

[Mr Walker]

You need to insert this into "This workbook"

Private Sub Workbook_Open()
range("a1").value = "YOURVALUE"
end sub

Hope this helps.

 

[Barrie Davidson]

Put this in the Workbook Open event (change the range and values accordingly):

Range("A1:B10").Value = "Barrie"

Regards,

 

[phantom1975]

You might want to also reference the sheet too:

Sheets("Sheet1").Range("A1").Value = "Barrie's head smells like cheese."