32 Bit And 64 Bit Api Declarations For Vba Developers
A whole heap of declarations for 32 and 64 bit operating systems.
Recent posts
Sumproduct To Sum Or Count Across Multiple Columns
Summary SUMPRODUCT is an incredibly versatile function that can be used to sum and count like SUMIFS or COUNTIFS, but with more flexibility.
Count Unique Values In A Range
Link to all xlsx Example Files: https://github.com/ExcelTitan/Excel_Formulas
Create A Table Of Contents
This one is pretty sweet. It creates a nicely formatted TOC sheet and a back button on each sheet that links to the TOC. If you happen to add a sheet, simply...
Use Vba To Join Cell Values With Either & Or Concatenate Formula
Join multiple string cells using one of 2 options, the code below shows how to choose the two, it boils down to what the user finds easier to read.