Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
MyList has has several columns showing the stock codes, their closing
prices, etc. The macro program I use runs down MyList and checks off the codes line by line against the ExchangeList. If the codes are found, indicating there were trading for them, it then updates the data on MYList. When there was no trading for a particular stock, Excel prompts me with the message: "Excel could not find the data you are searching for". At that stage I have to press the Enter Key to clear the OK sign and allow the program to continue on to search for the next code till the end. There were days when I had to press the Enter Key over a hundred times. Is there a way for the program to do this automatically by adding some codes to it? Thanks for any help. Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MSN stock quotes - Error message "problem displaying attributes" | Excel Discussion (Misc queries) | |||
"Unable to Read File" error message in Excel - solutions? | Excel Discussion (Misc queries) | |||
Deleted the pivot table - continue to get the "overlap" error message | Excel Discussion (Misc queries) | |||
Best way to trap error to MsgBox "Too many cell formats" | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) |