Hello All,
I am trying to understand the function and macro pasted below. I feel like I have a good grasp of the Public Function but the Private Sub is giving me a hard time. I was also wondering if the "Selection" in the "For Each c In Selection" was a variable or an excel defined use.
Thank you a thousand times!!!
Please Login or Register to view this content.
Last edited by Leith Ross; 02-01-2018 at 11:36 AM. Reason: Added Code Tags
No VBA expert, looks to me like the loop is adding an =IFBBERROR( ) round each cell in the selected range that is a formula and doesn't already have that.
Not sure what the first is doing.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
first one seems to be a custom iferror() where "-99998" is treated as an error.
If you want something done right... find a forum and ask an online expert.
Time flies like an arrow. Fruit flies like a banana.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks