Program has been running on Excel 2003 for several years. Now the customer needs to have it operational on 2007. One of the VB macros errors, here are the setails:
1) Macro is on worksheet "Main" and is called
"Private Worksheet_Change (byVal Target as Range)"
2) the statment is very simple
if Range('$E$4") = "" or Range("$E$7") = "" then
' some action to be taken
end if
Program errorr on the "if --- then" statement with the message
Run-Time Error '-2147417848 (80010108)'
Method '_Default' of object 'Range' failed
Absolutely no clue why this occurs. I have seen several other questions like this (dating back to 2002). None have an explanation.
I have send the error code to MS in the hope of someday getting a response. Someday has not arrived yet
I have to have this resolved else my contract is in jeopardy....
Thanks
1) Macro is on worksheet "Main" and is called
"Private Worksheet_Change (byVal Target as Range)"
2) the statment is very simple
if Range('$E$4") = "" or Range("$E$7") = "" then
' some action to be taken
end if
Program errorr on the "if --- then" statement with the message
Run-Time Error '-2147417848 (80010108)'
Method '_Default' of object 'Range' failed
Absolutely no clue why this occurs. I have seen several other questions like this (dating back to 2002). None have an explanation.
I have send the error code to MS in the hope of someday getting a response. Someday has not arrived yet
I have to have this resolved else my contract is in jeopardy....
Thanks
