VBA Debug: Workbook Open Rnage....Activate

[gheyman]

IT doesn't like
Sheet1.Range("C16").Activate

Private Sub Workbook_Open()
    Sheet1.Range("C16").Value = Environ("Username")
    Sheet1.Range("C17").Value = Now
        Sheet1.Range("C21").NumberFormat = "m/d/yyyy h:mm"
    Sheet1.Range("C16").Activate
    
End Sub

[Code/]
[Code\]

Thnaks

 

[Fluff]

You have to activate the sheet, before you activate the cell.
Alternatively use Application.Goto

 

[DanteAmor]

What do you need to activate the cell for?
Generally it is to get its value and for that you do not need to select the cell you can have this:

wValue = [COLOR=#333333]Sheet1.Range("C16").Value[/COLOR]