error 2042

  1. T

    VBA Range Function "N/a" error 2042...

    Hi guys, First time posting to a thread like this so apologies if I ask this query in a convoluted manner. That said, I am currently writing a macro for appending the range of an active worksheet to a .txt file for further analysis. Whilst I have successfully written this for a test excel...
  2. K

    Variant variable

    Greetings All, I have a problem with a vlookup, that is as follows: I have a list of strings and numbers that the vlookup refers to(call it lookup_value) and picks out the corresponding value in the coloumn next to the coloumn of strings and numbers. BUT, the problem is this: If I do a...
  3. F

    VLookup returns #N/A

    Hello there, I'm trying to do a VLookup in Excel VBA but it doesn't seem to be working properly. Here's the setup: In a worksheet named "Customers" I have a table of the customer's ID number (Column A) and his/her name (Column B) and other details in the following columns (eg. State in column...
  4. J

    VLOOKUP provides 2042 error

    I have 3 worksheets: 1. "Main": This is the output worksheet I will be working from 2. "Data": This has the underlying data worksheet 3. "Sheet2": This is seperate data that I want to check if it also appears in the "data" worksheet The "Data" worksheet has column A with a list of unique names...
  5. C

    Error 2042 - Returning row information

    Morning, Hope someone can help me out a bit here, I have workbook with 2 worksheets in it, using vlookup the first spreadsheet pulls information from sheet2 relating to elements in the first worksheet Currently I have a userform that finds any instance of the user inputted search and tells...
  6. R

    Excel VBA Error 2042

    I am writing a vba program to combine 3 worksheets in to a separate worksheet. The object is to take these three worksheets, in separate workbooks, that are being used as data entry, combine the unique rows in to a repository worksheet, in a 4th workbook, and produce metrics from the repository...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top