+ Reply to Thread
Results 1 to 2 of 2

Type mismatch error when assigning values resulting from a linear interpolation

  1. #1
    Forum Contributor
    Join Date
    04-07-2013
    Location
    France
    MS-Off Ver
    Excel 2011
    Posts
    166

    Type mismatch error when assigning values resulting from a linear interpolation

    Hi,

    I am constructing a linear interpolation code and I would like to assign the resulting values into the empty cells in my column.

    That is, in more detail:

    1. I identify empty cells in my range.
    2. I perform a linear interpolation.
    3. I assign the values into those empty cells.

    I do this while running a loop through the empty cells. However I keep on having the same problem with many codes I compile: Type Mismatch no.13...
    It happens in the line:
    Please Login or Register  to view this content.
    Would anyone know what is wrong? I keep on having the same problem all around and I am just not sure in which variable is the mismatch :/


    Thanks a lot!

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: Type mismatch error when assigning values resulting from a linear interpolation

    (How to) Upload a Workbook directly to the Forum
    (please do not post pictures or links to worksheets)
    • Click Advanced (next to quick post),
    • Scroll down until you see "Manage Attachments",
    • Click that then select "add files" (top right corner).
    • Click "Select Files" find your file, click "open" click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Click "Done" at bottom right to close the Attachment Manager.
    • Click "Submit Reply"
    Note: Please do not attach password protected workbooks/worksheets
    Ben Van Johnson

+ 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] Type Mismatch when assigning data from ranges (columns) to arrays
    By seigna in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 05-07-2013, 07:40 AM
  2. Run Type error 13 Type Mismatch
    By Affan Khan in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-13-2012, 12:58 PM
  3. [SOLVED] Run-type error 13 type mismatch
    By misop in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-05-2012, 04:08 AM
  4. Complile Error: Type Mismatch ??? After adding error trap
    By clemsoncooz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-22-2012, 03:50 PM
  5. Type mismatch error assigning range to array......
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-11-2012, 06:27 PM
  6. Conditional Formatting - Run Time Error '13' Type Mismatch Error
    By ksp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-17-2011, 07:37 PM
  7. Replies: 5
    Last Post: 08-08-2010, 03:03 PM
  8. [SOLVED] Help: Compile error: type mismatch: array or user defined type expected
    By lvcha.gouqizi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2005, 05:05 PM

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