Hello Yowser

I do pass the 'Thisworkbook' object by reference to the function but when I get an error when the line runs; 9 - subscript out of range. I setup a test to see if the called function can read a cell value from the calling workbook using the line below.

[code]
MsgBox Callingwb.Worksheets("Sheet4").Range("E4")
[/code/

'Callingwb' is set as "ByRef Callingwb" in the function header.

I know the object name is visible within the called procedure because I see it when i use 'callingwb.name'. So something wrong with the structure of my msgbox code?