error message.
 

Hello from Steved
I'm getting this error
method'select'of object'_worksheet'failed

Sub SaveNClose()
Range("B5").Select
Sheet1.Select
Range("B5").Select
ActiveWorkbook.Save
ActiveWorkbook.Close
End Sub

Please help

Thankyou.

Do this:


Sub SaveNClose()

Sheet1.Select
Range("B5").Select
ActiveWorkbook.Close True

End Sub


-Jack




"Steved" wrote:

Hello from Steved
I'm getting this error
method'select'of object'_worksheet'failed

Sub SaveNClose()
Range("B5").Select
Sheet1.Select
Range("B5").Select
ActiveWorkbook.Save
ActiveWorkbook.Close
End Sub

Please help

Thankyou.

Hello from Steved

I carried out what you asked and i'm getting
the below error, Am i doing something wrong

The objective of the macro is that if I am in
Sheet2 it will goto sheet1 and save.

method'select'of object'_worksheet'failed

Thanks.


-----Original Message-----
Do this:


Sub SaveNClose()

Sheet1.Select
Range("B5").Select
ActiveWorkbook.Close True

End Sub


-Jack




"Steved" wrote:

Hello from Steved
I'm getting this error
method'select'of object'_worksheet'failed

Sub SaveNClose()
Range("B5").Select
Sheet1.Select
Range("B5").Select
ActiveWorkbook.Save
ActiveWorkbook.Close
End Sub

Please help

Thankyou.

.