Thanks, but same error msg 1004.
Macro cannot be found.
Regards.
"S?ren Remfeldt" wrote in message
om...
Hi Stuart!
Try this instead
Application.Run _
"BofQUtilities.xla!InDirect_Menu_Routines.ReNumber BofQPages myCell,
ws,£Col
without the"()".....
It might work!
;-) Søren Remfeldt
"Stuart" wrote in message
...
From the Immediate window, this statement:
Application.Run "BofQUtilities.xla!InDirect_Menu_Routines.Test 1"
results in the following macro successfully running:
Sub Test1()
MsgBox ("Success")
End Sub
but this statement:
Application.Run _
"BofQUtilities.xla!InDirect_Menu_Routines.ReNumber BofQPages(myCell, ws,
£Col)"
results in an error message, saying the macro cannot be found.
The macro exists, and I'm fairly sure there are no typos.
Any ideas please?
Regards.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.524 / Virus Database: 321 - Release Date: 06/10/2003
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.524 / Virus Database: 321 - Release Date: 07/10/2003