Tough One! VBA namebox issues

[MichaelRSnow]

Hi there

Got a tough one for me

I have 2 workbooks
Workbook A - cell Value in A1 = 'SIB01'
Workbook A - cell Value in A2 = 'Open'
Workbook B - cell named 'SIB01' (via NameBox function)

I want a vba that copies value from A2, workbook A into the equivelant namebox in workbook B, but it only know the name of the namebox because it pulls this from the value in cell A1 workbook A.

Hope this makes sense? is it possible?

 

[Phanmore]

Sub namebox_test()
Sheets("Workbook_B").Range(Range("A1").Value) = Range("A2").Value
End Sub

 

[MichaelRSnow]

Thank you, I get an run time error 9

subscript out of range

 

[Phanmore]

Have you changed 'Workbook_B' to your workbook name?

 

[MichaelRSnow]

I have, the macro is run from a command button in workbook A, does that make a difference?