Activating Open Workbook from a Cell ref

[Lukey]

Hi,

I am trying to activate an workbook thats already open form a cell in the currently active workbook.

so far i have -

Windows(Filename:=Range("f49").Value).Activate

but it keeps giving me an error.

I've also tried a few variables of this using the "&" but to no avail.

Sorry for asking what seems like such an obvious question, but I just can't seem to get the right answer.

Thanks in advance

 

[VoG]

Try

Workbooks(Range("F49").Value).Activate

 

[Lukey]

(SOLVED) Activating Open Workbook from a Cell ref

Thanks very much that worked like a treat. I think that was about the only thing i didn't try.