Absolute Value -- Error type mismatch

**sokeefe14** · 05-18-2015, 09:45 AM

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

Please Login or Register  to view this content.

Any help would be appreciated!

Thanks,
Scott

**Norie** · 05-18-2015, 10:04 AM

Scott

Which line of code is the error occurring on?

Also what do you mean by an 'absolute value calculation'.

**sokeefe14** · 05-18-2015, 10:27 AM

The error is on the first line of the if statement.
Absolute value calculation in the column. So the column its checking for values > 3 (rm.column), has a formula in each cell that says =Abs((S2-AG2)/S2). So what I want the code to do is check if that value is > 3, and if so put a 4 in the exclude column. The reason I think it has something to do with absolute value is because I have a similar check on the cell next to it that works fine and the cells it is checking are a simp

**Norie** · 05-18-2015, 10:31 AM

If your calculation returns a number, absolute or not, it won't cause a mismatch.

Things that can cause mismatches are text values and errors in a cell.

Have you checked what the actual value of ActiveSheet.Cells(i, rm.Column).Value is when you get the error?

**sokeefe14** · 05-18-2015, 10:40 AM

How do I do that? I am looking at all the cells in that column and they all show numbers.

**Norie** · 05-18-2015, 10:42 AM

Can you upload a sample workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

**sokeefe14** · 05-18-2015, 10:45 AM

Unfortunately I cannot do that, the data is sensitive.

**Norie** · 05-18-2015, 10:49 AM

Are you sure you don't have any numbers stored as text?

Is the code definitely being run against the correct sheet in the correct workbook?

Do you have any headers?

**sokeefe14** · 05-18-2015, 11:38 AM

I figured it out. There were filtered cells that had a div/0 error so I had to adjust accordingly. Thank you for your help.

Absolute Value -- Error type mismatch

LinkBack

Thread Tools

Rate This Thread

Display

Absolute Value -- Error type mismatch

Re: Absolute Value -- Error type mismatch

Re: Absolute Value -- Error type mismatch

Re: Absolute Value -- Error type mismatch

Re: Absolute Value -- Error type mismatch

Re: Absolute Value -- Error type mismatch

Re: Absolute Value -- Error type mismatch

Re: Absolute Value -- Error type mismatch

Re: Absolute Value -- Error type mismatch

Thread Information

Users Browsing this Thread

Similar Threads

Run Type error 13 Type Mismatch

[SOLVED] Run-type error 13 type mismatch

Complile Error: Type Mismatch ??? After adding error trap

Conditional Formatting - Run Time Error '13' Type Mismatch Error

[SOLVED] Help: Compile error: type mismatch: array or user defined type expected

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions