Must be missing something simple here. Anyway, thought I would post it so someone can point me in the right direction.
I am trying to use the value of a name which is stored in workbook A from Workbook B. The name is called "debugmode" and stores a True/False value.
I get a subscript out of range error.VB Code:
Sub dosomething() If Workbooks("One").Names(debugmode).Name = True Then Cancel = True End sub
And then I tried a variation:
If Workbooks("tbm_intro.xls").Names("debugmode") = True Then Cancel = True
And got a type mismatch error.




Reply With Quote