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...

Some videos you may like

This Week's Hot Topics

  • Check VBA code to locate value in cell
    Hello this is the current code I have [CODE=vba] Private Sub TextBox1_AfterUpdate() Dim m As String Dim rx As String rx = Trim(TextBox1.Text)...
  • Reverse Numbers Formula
    Hello Everyone! My computer is Asus My Operating system is Windows 10. Can someone please help me with a formula that I can drag down (or up) to...
  • Count If Issue
    Hi all, I'm trying to create an spreadsheet which counts certain words in a cell only once and gives me a total. I can do this but some of the...
  • VBA Check for multiple cell values and copy the cell in column A
    Hello! So I have this code that checks for the values in column "L" in this case it's 25. But I want to change this code so that it actually...
  • Sending mails to specific recipients based on a cells value
    Good morning, I am trying to get excel to send out an email to different sales reps. So if row X is an error code of "999" then excel needs to...
  • Matching Number in Textbox
    Hello Excel Users, I come with a request. Hope all are doing fine. So I have 1 textbox to type in numbers etc. 12345 (it will always be 5...
Top