error 2042 in linked field


New Member
Jun 3, 2010
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?):


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


New Member
Jun 3, 2010
I figured out that I had a timing problem. So please disregard my post.

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...