9tanstaafl9
Well-known Member
- Joined
- Mar 23, 2008
- Messages
- 535
Could someone please tell me the difference between IsEmpty and isBlank and =""? I got a type mismatch error in one place where I had used ="". When I changed it to isEmpty(activecell) my macro ran fine.
I'm trying to learn and do things the right way, and I'm not sure why it works now, and whether or not I should fix my other instances of ="" even thought the code is working. When is each use appropriate?
In case it's relevant, USUALLY (though not always) I'm trying to test to see if my query returned anything.
Thanks!
I'm trying to learn and do things the right way, and I'm not sure why it works now, and whether or not I should fix my other instances of ="" even thought the code is working. When is each use appropriate?
In case it's relevant, USUALLY (though not always) I'm trying to test to see if my query returned anything.
Thanks!