Excel VBA
Convert Numbers to Sequential Letters with VBA
Convert positive numbers to compact sequential letter IDs such as A, Z, AA and BDWGN, and convert the letter sequence back to a number.
Read guide →Tips & Quick Guides
Practical tips for Excel, VBA and development
Short and practical solutions to common problems in Excel, VBA and application development.
Excel VBA
Find the Last Used Row in Excel with VBA
How to find the last used row in a worksheet or a specific column with Excel VBA.
Read guide →Excel VBA
Select Current Region without Headers
How to exclude the header row from an Excel VBA CurrentRegion selection.
Read guide →