Dears
May I ask you how to code the following request in VBA.
If my cell in column D is empty/blank then clear content in column F.
Example :
Through a loop, check all cells in column D.
If D1 is empty then clear content F1, etc etc
Tried several things but nothing worked.
Hope you can help me
Regards
Last edited by ozstrik3r69; 08-22-2018 at 02:58 PM.
This macro assumes you have headers in row 1 and your data starts in row 2.
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
How aboutPlease Login or Register to view this content.
Mumps1 & Fluff13 thank you for your help.
I used the one from Fluff13 because initially I wrote the same code but with a mistake.
And I really think that it is the best for me at this moment
See below what I had
Once again, thanks for your help folksPlease Login or Register to view this content.
Regards
Glad we could help & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks