VBA macro error

[Ed in Aus]

I have a VBA project that basically filters on column A (position numbers) and then adds up column 5 (costing %) this project sends an error back to the user if column 5 does not equal 100%. It usual works fine but with these numbers it doesn't... the columns in the centre are costing codes (not relevant) any ideas
15902 295000 295110 71001 25
15902 295000 295110 71002 16.67
15902 295000 295110 71003 41.66
15902 295000 295110 71006 16.67

 

[Ed in Aus]

Bingo something so small yet so hard to find. A lesson to look at the basics first I guess.

 

[tactps]

And to start at the beginning!

Lessons all around.

 

[Ed in Aus]

Thanks Guys works like a dream now