Assuming the other book contains the name of the sheet in cell A1 of sheet 1...

sheets(worksbooks("MyBook.xls").Sheets("Sheet1").r ange("A1").value).Select
--
HTH...

Jim Thomlinson


"douglass" wrote:

new to VBA.

trying to come up with a line of code that will open a specific worksheet
based on value in cell in another workbook. both workbooks are open.
--
douglass