Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unhelpful error message!
Can anyone shed any light on this please: I have a sub that converts a series
of text entries to numbers and copies them to another sheet. It works fine if it sits as a macro in Personal.xls, but when I moved it to a module in a working spreadsheet I got a wierd error message - a text box with a red cross and the figure 400 but nothing else! Hitting the help button brings up an empty window. Does it mean anything to anyone please? Thanks SJB |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unhelpful error message!
Try closing excel and reopening it. this might clear up the problem. I
believe this is just an intermittent bug in Excel, so the actions I described might help. -- Regards, Tom Ogilvy "SueJB" wrote in message ... Can anyone shed any light on this please: I have a sub that converts a series of text entries to numbers and copies them to another sheet. It works fine if it sits as a macro in Personal.xls, but when I moved it to a module in a working spreadsheet I got a wierd error message - a text box with a red cross and the figure 400 but nothing else! Hitting the help button brings up an empty window. Does it mean anything to anyone please? Thanks SJB |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unhelpful error message!
Hello Tom
Thanks for responding so quickly - unfortunately this didn't clear the problem. Best wishes Sue "Tom Ogilvy" wrote: Try closing excel and reopening it. this might clear up the problem. I believe this is just an intermittent bug in Excel, so the actions I described might help. -- Regards, Tom Ogilvy "SueJB" wrote in message ... Can anyone shed any light on this please: I have a sub that converts a series of text entries to numbers and copies them to another sheet. It works fine if it sits as a macro in Personal.xls, but when I moved it to a module in a working spreadsheet I got a wierd error message - a text box with a red cross and the figure 400 but nothing else! Hitting the help button brings up an empty window. Does it mean anything to anyone please? Thanks SJB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting unhelpful date format into helpful one? | Excel Discussion (Misc queries) | |||
People seeking help lack competency. Your HELP unhelpful | Excel Discussion (Misc queries) | |||
error message: compile error, argument not optional | Excel Programming | |||
changing the message in an error message | Excel Worksheet Functions | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) |