How to ignore blank cells in a find macro

**ANDREWA** · 08-14-2012, 04:57 AM

Hello, this is what i have so far. But if either of the search values from MyArr (A1 or A2) are left blank then it will search for a blank cell. How do I prevent this? Help much appreciated.

Please Login or Register  to view this content.

**MaczaQ** · 08-14-2012, 05:10 AM

Consider to use If condition in

Please Login or Register  to view this content.

**ANDREWA** · 08-14-2012, 06:30 AM

Thanks MaczqQ, so simple just couldnt see it. Have one other question, but will repost so I can mark this as solved. Thanks again

---------- Post added at 11:30 AM ---------- Previous post was at 11:27 AM ----------

How do I rate using scales? Where is the icon?

**Cutter** · 08-14-2012, 01:34 PM

Hi ANDREWA

You can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.