Test if column has any values

[dlow]

I would like to use this Sub but it is giving me the wrong result.

Please Login or Register  to view this content.

What I would like to do is just test the Col to see if there is any data at all in it. The Sub above is giving me a MsgBox "Not Empty" even when I see that the cells are empty & dont have formulas either. "I" is a helper Col that was populated & then deleted. My code runs & imports more data but on the 2nd go round "I" may or may not have data in it hence the test.

In summary I am looking for a quick & dirty way to test a Col for data [Could be a formula text or numbers].
Is that possible or am I asking too much from Excel?

TIA any help offered is greatly appreciated.

[sktneer]

You may try this to see if this works as per your requirement.

Please Login or Register  to view this content.

[dlow]

Yup, BoOM BaNG!!!

Now if I may inquire about what you did there? Did you concatenate two functions? Wow did not know you could do that.
What is even more interesting to me is how the 2nd is modified."), "*?")"

Please Login or Register  to view this content.

I would like to know what its called or something so I could learn about that snazzy trick.
Thx for sharing you time & knowledge.
+1Rep Point for you Good Sir Brovo

[sktneer]

You're welcome. Thanks for the feedback.

The first one is checking if the specified range contains a number and the second one is checking if the specified range contains a text. Both the function are used in IF with AND logical statement and if both are evaluated to be True, it returns the msg "Empty". Try these functions on your sheet to see how they work.

[dlow]

Yes it works sorry, & the thread is marked as "Solved." Thanks again for helping me out.

"Yup, BoOM BaNG!!!" was some of my American slang or "Pow Ping" say it after doing something really awesome. Anyways thanks your amazing, all the best sir.