error: sub or function not defined

[mark]

hi

whts usually the reason for such error. i have my private
function in "This Workbook" module and my sub
Testmyfunction () is module1.

thanks

 

[Chip Pearson]

Mark,

If a procedure is declared as Private, it can be called only from
procedures within the same module. What procedure, and where does
that procedure reside, is flagged as "not found".


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[kkknie]

Either you mistyped the name of the function or you declared the
function as Private. Declaring it as public, lets you call it from
another module.

K