Hi All,
I'm having a bit of trouble with this one. I'm looking to write a script that will find all cell errors (e.g., #VALUE, #NA, #REF, #DIV/0, #NUM!, #NULL!) and provide a list of the cell addresses of said errors in a userform. Ideally this list would be in a userform listbox to enable scrolling.
So far I have the below, but i'm having trouble with the cell address and list bit.
Any help would be greatly appreciated!HTML Code:
Create a userform with a label and a listbox.
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Just a small addition- you need an error handler in case SpecialCells fails
Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
Wow - this is great, works perfectly. Thank you so much!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. You can also 'Add Reputation' to those who helped you. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks