Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type Mismatch error while checking range value
I use excel with a xla add in to get data from a system called Khalix.
Anyhow, I call a function to refresh data in my workbook and need to figure out a way to confirm that it finished getting the data. Some formulas return #Value! when the data is not retrieved/refreshed. My solution is to loop until the cell doesn't equal #VALUE, but I get a type mismatch error when checking. I've used the immediate window and the cell value contains Error 2015 not #VALUE. Do Until lws_Template.Range("e13").Value < "Error 2015" For li_counter2 = 1 To 10000 Next li_counter2 lws_Template.Calculate Loop Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting - Run Time Error '13' Type Mismatch Error | Excel Programming | |||
Type mismatch using rnge as Range with Type 8 Input Box | Excel Programming | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
Type Mismatch error & subscript out of range error | Excel Programming | |||
Code works 1st time then Type Mismatch when checking for not blank cells | Excel Programming |