passing sheet address to subroutine

[Danny54]

what is a correct way to access a open workbook.sheet that is currently open when linking to a subroutine or a function?


ie..
i open two workbooks in the main routine and the based on a condition in the main routine i link to a subroutine. I can't figure out how to read a value on the open sheets from within the subroutine.

Thanks

 

[MARK858]

I don't really understand what you are asking, to access a cell in another open workbook you just reference the workbook...

Workbooks("TheOpenWorkbookName").Sheets("TheNameOfTheSheet").Cells(1, 1)