Take a look at
http://www.mvps.org/dmcritchie/excel/install.htm
which has a section on invoking macros and functions
from within a macro.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"dreamz" wrote in message
...
Leith Ross Wrote:
Hello Dreamz,
The code should be working as is. I have tried several variations of
the Copy and PasteSpecial to duplicate the problem, but I can't. I
created a UserForm with a checkbox, and placed the paste code into a
project module, and everything works. Which means there is something
else causing the problem. I look over your code again and see if I can
spot something.
Sincerely,
Leith Ross
hello,
thank you very much for your help. i appreciate it.
i have no idea why it's not working. i can't see any problem with the
code itself (the calculate procedure works if i paste it into the
procedure instead of using "call").
i also just tried putting the code in a different module and calling
it:
Code:
--------------------
Call Module3.Calculate
--------------------
neither procedure worked this time.
i guess i will never know what's wrong with this.
but thanks again. :)
--
dreamz
------------------------------------------------------------------------
dreamz's Profile: http://www.excelforum.com/member.php...o&userid=26462
View this thread: http://www.excelforum.com/showthread...hreadid=480621