Leith Ross Wrote:
Hello Dreamz,

To test if the data is really on clipboard, select a cell on a
worksheet and select Paste Special from the Excel Edit menu and see if
it does Paste the date. If it does then problem lies with Calculate, if
not the problem is most likely in Listsub.

Thanks,
Leith Ross
yes, it is. i can paste after the procedure finishes, which means
listsub works (because it's just supposed to copy).

i have no idea what's wrong with the calculate procedure, though.


@david: thanks. i'll have a look.


--
dreamz
------------------------------------------------------------------------
dreamz's Profile: http://www.excelforum.com/member.php...o&userid=26462
View this thread: http://www.excelforum.com/showthread...hreadid=480621