I have a macro that checks the range B2:E for cells that are blank. When the user clicks a button the macro runs and fills the cell with red. I want to check columns B, D, and E but not C because C is an optional field.
The problem I am having is that it seems to be working except it is also formatting column C by filling it with red, the column I wanted to exclude.
I do not want to use conditional formatting.
My code is below
Please Login or Register to view this content.
Maybe like this:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Rewritten code:
Please Login or Register to view this content.
Thank you! This worked beautifully
Last edited by splunk76; 06-15-2021 at 09:21 AM.
Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
I'm confused … I thought you said it failed, but you've edited the post.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
Will do!
I do have a related question. I want to add this logic on the Before Close event, but since the sheets are protected I am running into an issue with the portion
I get the error message that I cannot use that command on a protected sheet. I know the password, but when I try to unprotect the sheet it doesn't work and gives me an out of range error
Set rTest = rInterest.SpecialCells(xlCellTypeBlanks)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks