Good afternoon, I hope you're all well.
I'm having an issue with a bit of VBA, where all it's doing is selecting another worksheet.
Typically, I would have used:
As users sometimes change the worksheet's name, I wanted to use the sheet's codename - Example, I've called it "Page"
Using the code:
When I do this, it's giving me a "Reference is Invalid" error.
Can someone let me know what I'm doing wrong here?
Much appreciated.
Thank you.
Regards
Marhier
I'm having an issue with a bit of VBA, where all it's doing is selecting another worksheet.
Typically, I would have used:
VBA Code:
Sub CallSheet()
Sheets("Example").Select
End Sub
As users sometimes change the worksheet's name, I wanted to use the sheet's codename - Example, I've called it "Page"
Using the code:
VBA Code:
Sub CallSheet()
Page.Select
End Sub
When I do this, it's giving me a "Reference is Invalid" error.
Can someone let me know what I'm doing wrong here?
Much appreciated.
Thank you.
Regards
Marhier