Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro bombing out
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?! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro bombing out
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro bombing out
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?! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro bombing out
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro bombing out
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro bombing out
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro bombing out
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 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro bombing out
I've now sent an email from various email addies... even from a web-based
email service, but they all return. Do you have another email addy? Sorry for the inconvenience... "Leith Ross" wrote: 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 |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro bombing out
Hello CyberFox, Sorry, I don't have another email address. You'll have to post th workbook so I can download it from the Excel Forum site. Since your ar not a registered user on this site, I can't walk you through the step to post the workbook. If all else fails you can register as a member a this site for free. Sincerely, Leith Ros -- Leith Ros ----------------------------------------------------------------------- Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846 View this thread: http://www.excelforum.com/showthread.php?threadid=47972 |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro bombing out
I'm going to try one more time from yahoo...
Otherwise, how / where do I register as a registered user? I thought I was a registered user already... "Leith Ross" wrote: Hello CyberFox, Sorry, I don't have another email address. You'll have to post the workbook so I can download it from the Excel Forum site. Since your are not a registered user on this site, I can't walk you through the steps to post the workbook. If all else fails you can register as a member at this site for free. 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 |
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro bombing out
Hello Cyberfox, I haven't gotten it yet. I have 114 mail items and not one is fro you. To register on this site go to http://www.excelforum.com/ an register. Once you have done that, jump to the Excel Programming foru (you will be presented a list after you logon). At the top left an bottom left of posts you will find a button marked *New Thread*. Clic it and a user interface will be diplayed similar to an email setup Enter a *Title* and *Message*. Below the message window you see a fram marked *Additional Options*. Click the button marked *Manag Attachments* and you can then browse for your file and upload it to th forum. Sincerely, Leith ros -- Leith Ros ----------------------------------------------------------------------- Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846 View this thread: http://www.excelforum.com/showthread.php?threadid=47972 |
#13
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro bombing out
I have uploaded it on the Excel Programming forum... pse check and get back
to me. You can use my email addy - I did receive your email. I'll respond via the discussion forum... cool? Thx a lot "Leith Ross" wrote: Hello Cyberfox, I haven't gotten it yet. I have 114 mail items and not one is from you. To register on this site go to http://www.excelforum.com/ and register. Once you have done that, jump to the Excel Programming forum (you will be presented a list after you logon). At the top left and bottom left of posts you will find a button marked *New Thread*. Click it and a user interface will be diplayed similar to an email setup. Enter a *Title* and *Message*. Below the message window you see a frame marked *Additional Options*. Click the button marked *Manage Attachments* and you can then browse for your file and upload it to the forum. 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 |
#14
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro bombing out
I am struggling my ass off to send this file to you via my yahoo! mailbox...
I have managed to upload it onto the excelforum.com website, though... pse check if you can find it... Thx "Leith Ross" wrote: Hello Cyberfox, I haven't gotten it yet. I have 114 mail items and not one is from you. To register on this site go to http://www.excelforum.com/ and register. Once you have done that, jump to the Excel Programming forum (you will be presented a list after you logon). At the top left and bottom left of posts you will find a button marked *New Thread*. Click it and a user interface will be diplayed similar to an email setup. Enter a *Title* and *Message*. Below the message window you see a frame marked *Additional Options*. Click the button marked *Manage Attachments* and you can then browse for your file and upload it to the forum. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |