Marko,
Change the declaration of the variable to Public. I.e.,
Public debriefBook As Workbook
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"marko" <no@email wrote in message
...
Hi all,
This works
Dim debriefBook As Workbook
Sub booktest()
Set debriefBook = ThisWorkbook
MsgBox debriefBook.Name
End Sub
but if I call a function from a different module,
Sub ShowName
Set debriefBook = ThisWorkbook
ShowMe
End Sub
and this is in a different module!
Function Showme()
MsgBox debriefBook.Name
End Function
It doesnt work, it says "object not defined"
I'm not sure whats going on.