Alternate Sheet/Cell Reference in VBA

[elittos]

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??

 

[DanteAmor]

Hi and welcome to MrExcel

Try:

Sub test()
  Dim wb As Variant
  wb = Range("Current!B2")
  MsgBox (wb)
End Sub