I want cells D18, E18 & F3 to clear when the contents of B5 changes
I have used this code to get D18 to clear, but cant get it to include the other cells
Please Login or Register to view this content.
I want cells D18, E18 & F3 to clear when the contents of B5 changes
I have used this code to get D18 to clear, but cant get it to include the other cells
Please Login or Register to view this content.
Barring any worksheet / workbook protection, you should be able to add the following to the if statement below the line for D18:
If that doesn't work, let us know if you receive any sort of error.Please Login or Register to view this content.
If someone helped achieve your solution, consider clicking "* Add Reputation" on their post.
If your question has been answered, mark the thread as [SOLVED] using the Thread Tools menu at the top of the thread.
How aboutPlease Login or Register to view this content.
this worked thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks