I need something which I think is very simple, but because I'm new to VB, I'm missing.
1. I need to determine if a specified cell is empty or has a value;
2. I need to determine if the value in a specified cell is type date
Can you, please help?
I need something which I think is very simple, but because I'm new to VB, I'm missing.
1. I need to determine if a specified cell is empty or has a value;
2. I need to determine if the value in a specified cell is type date
Can you, please help?
So Many different ways!
Here is an example of one way :
This first checks to see if Cell A1 is empty and if it is not empty it checks to see if it is in Date Format:
Hope this helps, let me know how you go!![]()
Please Login or Register to view this content.
Use IsEmpty to check for a completely empty Cell
![]()
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thanks everybody. I addapted both ideas to my macro and it worked.![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks