Results 1 to 11 of 11

currency value assigned to variable Error 2023

Threaded View

  1. #1
    Registered User
    Join Date
    06-20-2024
    Location
    Columbia, MD
    MS-Off Ver
    Microsoft365
    Posts
    12

    currency value assigned to variable Error 2023

    I have the following line in my VBA code.


    billrte = Application.VLookup(startNum, Worksheets("" & sheetnm & "").Range("A2:M9999"), 16, False)

    billrte is declared as a variant
    startnum is set at 5
    sheetnm is set to the tab name of IAAI

    This exact line of code appears 8 times previous as I am assigning data to variables and it works every time, until it gets to billrte where it assigns the value of "Error 2023"

    The issue appears to be that the value in the worksheet is a currency.

    If I change the variable to be a currency type it throws a "Type Mismatch" error.

    I have searched the forum and found nothing close to this issue.

    Any help is truly appreciated.

    Tim
    Last edited by thabart1; 06-27-2024 at 12:09 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Date error: 29/2/2023 shows Wed 01/03/2023
    By SunOffice in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-26-2023, 08:38 AM
  2. Replies: 5
    Last Post: 03-09-2023, 03:29 AM
  3. Need Formula to Convert this Date Format 2023.02.28 to this 28-Feb-2023
    By gr445854 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-11-2023, 07:04 PM
  4. Replies: 1
    Last Post: 02-03-2023, 04:54 PM
  5. Run-Time Error 2023
    By SKINRIP in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-23-2022, 09:52 AM
  6. [SOLVED] Error 2023: How to identify cell in For Each Loop?
    By VAer in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-12-2018, 12:21 AM
  7. [SOLVED] Error 2023 - triggered by variable - Cant find mistake
    By Taktiker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-22-2012, 09:11 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1