Using Column Numbers in Macros and Formulas
Key points
- Pick the column
- Find its number
- Use it in code
A column number found with Excel Column Converter can be used directly in macros or formulas.
Steps
- Pick the column
- Find its number
- Use it in code
Using a number for the column makes later edits easier.
Use "Excel Column Number and Letter Converter" (free)
Tools that go well with this
- Convert Excel to CSV or JSON: Convert an Excel sheet to CSV, TSV or JSON.
- Convert CSV to Excel (.xlsx): Convert a CSV to an Excel (.xlsx) file.
- Merge, Split and Pick Columns from CSV: Merge CSV files, split by rows, or keep only chosen columns.