GoTo Reference
Hello, Can someone tell me if it's possible to refer to a worksheet
generically, when using the GoTo function, so if the worksheet name changes,
the code will still execute?
For instance, I have the following:
Application.Goto Application.Worksheets("Sheet1").Range("A154")
If the the Sheet1 name changes, the process halts. Can Sheet1 be reference
in a manner that regardless of the text within the worksheet label, the code
will still take the user to range("A154")?
Any and All Help is Appreciated - Thanks
|