Error Checking using offsets as Formulas

**ukhellfire** · 03-04-2013, 07:48 AM

Hi Guys,

Having a bit of trouble with some code im trying to implement...

What im trying to have it do, is check that cell "G20" is equal to "A20 * F20"... now i can do that, but now comes the fun part...

in each of those coloumns there are about 6/7 different values, i need to check each row, one by one... if that makes sense?
thought id add, the values in column A are quantities, column F are unit prices and column G are the net prices... obviously i need to make sure that the net price is the same as the unit price * quantity... wow i hate explanations! hahaha!

ill attach the code, that should make alot more sense. if you need the spreadsheet attached to, let me know and ill put up a "cut down" version...

Please Login or Register  to view this content.

thanks in advance! u guys are awesome here!

**Norie** · 03-04-2013, 07:52 AM

Is the code not working?

**ukhellfire** · 03-04-2013, 07:53 AM

no it keeps telling me that they are all unit prices even when they are not... why should that work then? would it help if i uploaded the sheet?

**Norie** · 03-04-2013, 07:58 AM

I think I know what the problem is, but it might be good to see the worksheet.

In this line of code you are comparing the value from Item to the string "sum(Item.Offset(0, -1)) * (Item.Offset(0,-6))"

Please Login or Register  to view this content.

Don't know why but I've got a feeling that might return false.

Try replacing with this.

Please Login or Register  to view this content.

**ukhellfire** · 03-04-2013, 08:14 AM

ahhh now that works... but its backwards :| but i think thats my fault, i need to make it check if there "not" the same then mark red and throw up a message box...
this is what ive come up with - not very imaginative i know but.... IT WORKS!

Please Login or Register  to view this content.

Norie, you are once again a life saver! apparently i havent got my head round quite as many of these syntax's as i had thought.

the original code never threw up any errors, its just didnt do anything if there were errors (which i specify)... but im there! i think that was your code originally wasnt it Norie?