Find in VBA finds first instance of similar object being searched but not exact object

Below is the section of code I need help with. VBA is summing the correct range however it's entering that data point at an incorrect location. It's running the code for the first instance it finds "Electronics" which is further up the spreadsheet under "Consumer Electronics". Is there a way I can search for only what's in quotes rather than anything that's contained in the quotes? This would be the ideal solution. Another alternative that would be as effective for this case but not neccessarily all cases would be to establish my search range such that it won't include "Consumer Electronics". Example .Range("C100:C10000").Find instead of .Columns("C:C").Find

Please Login or Register  to view this content.

You should be made aware of the entirety of the Range.Find method. See link

http://msdn.microsoft.com/en-us/libr...ffice.15).aspx

With that being said, it sounds like you are having an issue with xlWhole vs xlPart

Please Login or Register  to view this content.

You can also work with some of the other parameters to acheive your desired results.

Maybe?

Please Login or Register  to view this content.

Thanks a lot stnkynts and JOHN H. DAVIS! This works flawlessly.