Good afternoon,
I am trying to test if a cell is empty, if it is then I want to do nothing "", but if it contains text or a number I want to insert "full" in the adjacent column. I can test a single cell with the attached code, but I need it to loop through the full column, can any one help please
Please Login or Register to view this content.
Please Login or Register to view this content.
Hi, deek,
can you explain if the cells are reaölly empty or filled with formulae? If they are empty you may use something like
And to be honest "MT" isn´t really empty for me.Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Here's another:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Guys,
many thanks all of these solutions work for me. its great to get so much help in a short time.
thanks again
DeeK
You're welcome and thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks