I'm trying to build a file name, based upon a value in another sheet, in VBA.
Windows("FT_" & Current!B2 & ".xlsx").Activate
Current is a valid sheet name and cell B2 does contain valid data
To test, I tried:
wb = Current!B2
msgbox(wb)
I get the same error, run time error 424, either way.
What am I missing??
Windows("FT_" & Current!B2 & ".xlsx").Activate
Current is a valid sheet name and cell B2 does contain valid data
To test, I tried:
wb = Current!B2
msgbox(wb)
I get the same error, run time error 424, either way.
What am I missing??