I've got a macro that has no errors - I can vouch for this because when I
press and hold F8, all procedures execute perfectly. The problem is that it
contains a huge loop (some select statements within if then's within a for
next) and the macro stops on one line but at different points of execution
the whole time. Any suggestions?!

All your F8 test shows is that your code doesn't have *syntax* errors. But
clearly, something else is wrong: you've got a memory leak, or you're not
cleaning up adequately as you go, or you're overflowing your system, or some
of the things you're processing within your loop have unexpected attributes
....

You'll need to provide more info.


"CyberFox" wrote in message
...
I've got a macro that has no errors - I can vouch for this because when I
press and hold F8, all procedures execute perfectly. The problem is that
it
contains a huge loop (some select statements within if then's within a for
next) and the macro stops on one line but at different points of execution
the whole time. Any suggestions?!

Hello Cyberfox,

To give you an answer would require seeing the code. Can you post it or
attach the workbook as zip?

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=479724

I know this might not look like the tightest piece of code, but it was done a
bit slap-dash and in a hurry. What it needs to do is the following:
1. I have a list of stock codes (no duplicates).
2. In another sheet it has a part of this stock code with components to make
up this stock code (assemble it). These componenets are in columns, but
different parts has different components.
3. What the macro must do is check if a component is used, then add a line
if it is and copy the component part and quantity into the first sheet.

How do I attach a workbook in this forum?
Regards,
W

Hello Cyberfox,

Email me a copy of the workbook to .

Thanks,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=479724

I mailed it off yesterday and haven't heard anything from you since... just
wondering if you did receive it.
Rgds,

"Leith Ross" wrote:


Hello Cyberfox,

Email me a copy of the workbook to .

Thanks,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=479724

Hello Cyberfox,

I did not recieve the workbook you emailed yesterday. Try resending it.
My email is

Thanks,
Leith Ross


--
Leith Ross


------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=479724