ExcelBanter - Reference is not valid

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Reference is not valid (https://www.excelbanter.com/excel-worksheet-functions/68362-reference-not-valid.html)

Steved

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.

Steved

Reference is not valid

Hello from Steved

Thankyou I got the answer .

Application.Goto Reference:=Worksheets(1).Range("A5")

"Steved" wrote:

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.

All times are GMT +1. The time now is 03:47 AM.