Hello everyone,
I came across this function macro. It looks pretty simple yet I have no idea how to understand it particularly the variable defined as Name.
Would someone be able to explain please as I never came across this before and I'm still in the bottom learners when it comes to vba.
Thank you.
Please Login or Register to view this content.
It checks whether there is a defined Name (Formulas tab, Name manager) with the specified name in the workbook.
Everyone who confuses correlation and causation ends up dead.
Looks like it was written in French, either because the author was French or s/he was avoiding using reserved words like Name and Names. Rory has explained the reason/use for/of the function.
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
Hi there,
The function is used to determine whether or not a specifically-named workbook-level Name has been defined in a workbook.
The following code shows an annotated English-language version of the routine, and also an alternative way of determining the result:
Please Login or Register to view this content.
Hope this helps.
Regards,
Greg M
Last edited by Greg M; 09-06-2021 at 07:07 AM. Reason: Typo corrected
I finally managed to understand the whole function. Very grateful for all your help and contribution. All best.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks