Thread: SaveNClose
View Single Post
  #1   Report Post  
Steved
 
Posts: n/a
Default SaveNClose

Hello from Steved

Please if I am working in an other worksheets and I want it to goto A5
before it goes to A5 in Worksheet1 and saves what is required

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