I have written code to clear #Value items in Col b on sheet "statement" but these items are not being cleared
Please Login or Register to view this content.
It would be appreciated if someone could assist me in amending my code
I have written code to clear #Value items in Col b on sheet "statement" but these items are not being cleared
Please Login or Register to view this content.
It would be appreciated if someone could assist me in amending my code
Since you don't show us what it's doing and how the 'valid' values have been added; your 'correction' code makes no sense.
The error is due to a formula error of some kind, in Formulas you can use the ISERROR() function, look that up.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Those are not formulas, so you'd need:
Please Login or Register to view this content.
Rory
@rorya: you're giving the answer that the OP has in the macro
No, I'm not. Read carefully.
Thanks for help Rory
Your code works 100%
No Problem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks