Hello Experts,
Need your help in understanding why i am failing in the below VBA code
What i want results is if B15 is not empty and one of the cell in Range(C15:i15) is empty, give the error - code is working fine in the first if condition
If B15 is empty and one of the cell in C15:I15 is not empty, give the error - Not working
Kndly help me out on this.
Please Login or Register to view this content.
For 1st part
If you want to test for not empty
If Not IsEmpty(Range("B15").Value) Then
Another way of writing:Please Login or Register to view this content.
Option Explicit
Please Login or Register to view this content.
Last edited by AB33; 11-27-2016 at 12:02 PM.
In the 2nd part of the code, you didn't have B15. Try this...
Please Login or Register to view this content.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
That was so quick help. will let you know the results in some time
thanks a lot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks