Excel VBA question
 

MegaSack DRAW - 6pm Christmas Eve - LIVE on our YouTube Channel

[Closed] Excel VBA question

2 Posts
2 Users
0 Reactions
65 Views
 mrmo
Posts: 10710
Free Member
Topic starter
 

what have i done wrong?

If Range("c32").Value + Range("d32").Value + Range("e32").Value + Range("f32").Value + Range("g32").Value <> Range("g29").Value Then
MsgBox "Product 1 required and called off do not match"
GoTo Problem
End If

I have set the numbers in the cells so they don't match but no result.


 
Posted : 03/09/2009 11:38 am
Posts: 0
Free Member
 

Works fine for me??


 
Posted : 03/09/2009 11:45 am
 mrmo
Posts: 10710
Free Member
Topic starter
 

I hate Excel, how can retyping the line make it work!!!!!! it is exactly the same as it was!!"!!!!!!!!"!"£$"!£$


 
Posted : 03/09/2009 11:56 am