Results 1 to 9 of 9

Absolute Value -- Error type mismatch

Threaded View

  1. #1
    Registered User
    Join Date
    05-06-2015
    Location
    virginia, USA
    MS-Off Ver
    2013
    Posts
    37

    Absolute Value -- Error type mismatch

    Hi all,

    I am running a macro that classifies exclusions in a data set. Everything works fine except one thing. I am checking to see if the value in a set column is greater than 3, if so I want it to set the exclude value to 4. I have similar things written for all of the other checks, but the difference with this column is that it is an absolute value calculation. The code for this section is below. It returns error type mismatch

    For i = 2 To ActiveSheet.Cells(Rows.Count, rm.Column).End(xlUp).Row
        If ActiveSheet.Cells(i, rm.Column).Value > 3 Then
            ActiveSheet.Cells(i, Excl.Column).Select
            ActiveCell.Value = 4
        End If
    Next
    Any help would be appreciated!

    Thanks,
    Scott
    Last edited by sokeefe14; 05-18-2015 at 11:40 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 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
  2. [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
  3. 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
  4. 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
  5. [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