What Are VB Projects, Objects, Forms, Modules and Procedures?

ByRick

In the Excel Visual Basic Editor (Alt+F11), display the Project Explorer (Ctrl+R). Usually (and in this picture), it appears at the top left, under the toolbars: In Project Explorer, you will see a VBAProject for every Excel file that is open.  The list will include the hidden Personal Macro workbook, Personal.xlsb, if you have personal macros….

|

Excel Functions You Never Need!

ByRick

Why would I tell you about Excel Functions you will never need?  Well, you might be using them now, and not be aware that there are simpler, more elegant alternatives. Are you using any of these: CONCATENATE, CONCAT, PRODUCT, POWER, DAYS, or DAYS360?  Then read on… CONCATENATE and CONCAT to Join Strings Syntax: CONCATENATE(text1, [text2],…