Hi,
What is the abbreviation for defined names in Excel, for Tables users used to use tbl_ like tbl_user?
What is the abbreviation we start the defined name with for defined names?
I do understand that it is not mandatory, but just to organize things.
Shall I use dfn_ or nme_
What are the abbreviations most users used to use? Or at least known for most users?
Last edited by daliye; 12-24-2023 at 08:01 AM.
thnx!
d!
microsoft excel, latest 365, 64-bit!
There really is no rule for this, other than the name cannot start with a number, contain special characters or include spaces.
In VBA it all comes down to personal preference.
Personally I like to use a DNR prefix for a dynamic named range and NR for s static named range.
Just make sure it makes sense to you now and that you'll still understand what it means when you revisit the code 6 months later.
BSB
Thanks a lot @BadlySpelledBuoy
For defined names which hold TRUE/FALSE values, I use the prefix bln (example: blnTaxExempt). For most other names, I use rng as the prefix (example: rngLowTaxRate). There realy isn't a hard and fast rule as BadlySpelledBuoy says.
Excel 365 user. To unblock a downloaded macro-enabled workbook, go to your "Downloads" folder > right click on the workbook name > click 'Properties' > check the 'Unblock' checkbox. You can now open the workbook.
Thanks a lot @deadlyduck
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks