Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Value Assignment Failure in Event Proc
A 3rd-party component I use in Excel VBA is talking to a data service. It
fires lots of events that are caught in a class event proc I wrote. That proc formulates a range reference and makes a range.value = quote.last assignment. The assignment throws an error that suggests the range name is invalid or nothing. But, that is not so. If I interrogate range.address in Immediate, the address is correctly shown. This error is sporadic, and occurs well under 1% of the event handler entries. Can anyone think of what might cause this relatively infrequent assignment error? BTW, a set statement like "set MyName=ws.name("abc")" also throws the same error. It, too, is an infrequent occurrence. Thanks for any suggestions you may have. -- -wcs |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cells Within Range Failure? | Excel Programming | |||
Formulas assignment from array to range in VSTO Excel doesn't work | Excel Worksheet Functions | |||
Is it safe to add event proc. to ThisWorbook module, if yes how? | Excel Programming | |||
ClearContents in event proc raises error | Excel Programming |