Within my spreadsheet i have say cell A1 containing a name, lets say fredbloggs.

I then have a macro which contains the line

Windows("fredbloggs.xls").activate

because there is also a sheet in that same name.

Instead of the macro line saying "fredbloggs.xls" is there any way of putting the cell reference of 'A1' within the macro line ?

So in essence the window that will be opened will be the one named in cell A1 on the spreadsheet ?

Your comments are greatly valued

Thank you

Darren