This blog will contain useful tips and tricks to make using Excel easier. It's a great piece of software, but is so complex that it takes years to master. Luckily The Master of Excel is here to help!
Excel VBA tip: use "VBA." to show a list of available functions
If you want to know which VBA functions are available, type "VBA." (no quotes). Provided you have Auto List Members switched on in the VBA options you will be shown a list of all of the available functions:
No comments:
Post a Comment