Trim code to exit code if cell is empty

**excellenthelp** · 10-23-2013, 11:57 AM

Excellers,

I am wondering what I am writing incorrectly... perhaps the reference to the range?

ERROR:
Run-time error '13': Type mismatch.

Formula:

Please Login or Register  to view this content.

Thanks for your help!

**Norie** · 10-23-2013, 12:04 PM

You can't use Trim on multiple cells and you can't compare multiple cells to one value like that.

**excellenthelp** · 10-23-2013, 12:08 PM

So I will have to write a line for individual cell?

Is there a better way to prevent the code from running if the range (C3:C6) is empty?

Re: Trim code to exit code if cell is empty