Our great sponsors
-
VBA-General
A repository of various modules and classes for interacting with Excel and doing other... things.
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
You mentioned having easy access to column headers, which was precisely why I created the GetHeaders function in my ExcelAPIs code library. You give the function the worksheet, with the header row number, and it will returns a dictionary of all the headers with their column numbers. So you can refer to column numbers by name and still get their corresponding column number location. For example: TSheet.Cells(RowCounter, Headers("dCountry"))
NOTE:
The number of mentions on this list indicates mentions on common posts plus user suggested alternatives.
Hence, a higher number means a more popular project.