|

Should I use a VBA Macro Function or Call a Worksheet Function?

ByRick

If the function you want to use exists in Excel VBA, use that.  It will be faster and cleaner, and work in all Microsoft Office programs, not only in Excel.  Here is a full list of Excel VBA Functions.  If the function you want is not there, but exists in the Worksheet, you may be…

| |

How to Use a Worksheet Function in a Macro: Proper Case Names

ByRick

In some cases, VBA does not have a specific function, but the Excel Worksheet does. This Excel Visual Basic (VBA) code example demonstrates: How to call that Worksheet Function from a Macro. In this particular example, how to call the Worksheet Function =PROPER() from VBA. The function to downcase parts of surnames that normally appear…