Hoping someone can help. I'm having trouble referencing a cell in a linked spreadsheet. The linked spreadsheet was not written by me. I think the cell is part of an array function, but to honest, I'm not sure.
I have a cell in my ss that is set to equal the linked cell. The problem is that whenever I try to evaluate the cell in my spreadsheet, I get the 2042 error. All I'm trying to do is test if the value is 0 or a number greater than zero. Both fields (the one in the linked ss and the linked cell in my ss) display the value "0", but when my vb hit its, I get a type mismatch and when I watch the expression it shows the error 2042.
My guess is that there's a trick to getting this to work.
The formula in the linked ss cell is as follows (does this indicate an array formula?):
=ssonp548|ord!id1332421934?remaining
I can post code, but the basic idea is I get a type mismatch when trying to compare the field to 0 or "0".
I've tried copy and paste and directly comparing in VB. Always get the type mismatch because the field evaluates to 2042 when I'm watching it even though on the worksheets it equals 0.
Thanks in advance. Hope this isn't too rambling
I have a cell in my ss that is set to equal the linked cell. The problem is that whenever I try to evaluate the cell in my spreadsheet, I get the 2042 error. All I'm trying to do is test if the value is 0 or a number greater than zero. Both fields (the one in the linked ss and the linked cell in my ss) display the value "0", but when my vb hit its, I get a type mismatch and when I watch the expression it shows the error 2042.
My guess is that there's a trick to getting this to work.
The formula in the linked ss cell is as follows (does this indicate an array formula?):
=ssonp548|ord!id1332421934?remaining
I can post code, but the basic idea is I get a type mismatch when trying to compare the field to 0 or "0".
I've tried copy and paste and directly comparing in VB. Always get the type mismatch because the field evaluates to 2042 when I'm watching it even though on the worksheets it equals 0.
Thanks in advance. Hope this isn't too rambling