Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|