+ Reply to Thread
Results 1 to 3 of 3

Small Issue with Type Mismatch and Invalid Qualifier when setting variable value from cell

  1. #1
    Registered User
    Join Date
    02-02-2012
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    42

    Small Issue with Type Mismatch and Invalid Qualifier when setting variable value from cell

    Hello,

    I am haveing a small issue I am trying to set a variables value based on the value of a cell in a row that was searched for. Heres my code:

    Please Login or Register  to view this content.
    the Variable LengthNAAMS is set as a 'Long" (I have tried it as a string and I get the same error.)

    Right now it says Type Mismatch Error
    But if I change it to:
    Please Login or Register  to view this content.
    It changes to Invalid Qulifer Error.

    I have also tried this:
    Please Login or Register  to view this content.
    But the error I get then is object variable or With Block variable not set.


    Not sure how to fix this. If the code doesn't make sense it is supposed to find a Value in Column F and set the variable "S" to that row than select the value of the 7 cell over in row "S" and set the Variable LengthNAAMS to the value of that cell.

    Anything is helpful ! Even a whole new way of doing this
    Last edited by TomToms; 10-10-2014 at 07:28 AM.

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Small Issue with Type Mismatch and Invalid Qualifier when setting variable value from

    Close:
    Please Login or Register  to view this content.
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    02-02-2012
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    42

    Re: Small Issue with Type Mismatch and Invalid Qualifier when setting variable value from

    Wow, so simple yet I still missed it... Thankyou so much

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Invalid Qualifier to a Valid Qualifier (Application)
    By exceltabz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-16-2014, 11:31 AM
  2. [SOLVED] Invalid Qualifier
    By Antares19 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-03-2012, 08:48 AM
  3. Compile Error: Invalid Qualifier in column sum/cell naming program
    By xioncrush in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-09-2007, 12:35 AM
  4. [SOLVED] Setting range object--Type mismatch if template not used
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-25-2006, 12:25 PM
  5. [SOLVED] Invalid Qualifier
    By Stuart in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-21-2005, 11:06 AM

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