View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steved
 
Posts: n/a
Default Reference is not valid

Hello from Steved

Sub SaveNClose()
Application.Goto Reference:=Worksheets(1).Range("A5").Activate
ActiveWorkbook.Close True
End Sub

Below is giving an error Reference is not valid
Application.Goto Reference:=Worksheets(1).Range("A5").Activate

What do I need to correct please.

Thankyou.