Activate Window based on A1

[bobaol]

Hello, I have a macro to go to many Windows. Here is the hard-coded version of one window I am activating. I want to activate the window based on cell A1. Cell A1 will have the value of the window name in it.

Sub Macro44()
Windows("Raw_Tables_18.xlsm").Activate
Application.Goto Reference:="R1C1"
End Sub

I tried this, but it does not work.

Sub Macro45()
Windows(range("a1")).Activate
Application.Goto Reference:="R1C1"
End Sub

Any help is appreciated. Thanks in advance.

 

[kevin9999]

The following works for me:

Sub MacroA1()
    Dim s As String
    s = Range("A1")
    Windows(s).Activate
    Range("A1").Select
End Sub

 

[bobaol]

Ho Ho Ho! thank you for the present! it works. Very grateful.

 

[kevin9999]

Ho Ho Ho! thank you for the present! it works. Very grateful.

Happy to help, and Merry Christmas to you