💻 Software
Select an entire column minus header row in an Excel macro
Fresh6 days ago
Mar 15, 202686674 viewsConfidence Score0%
0%
Problem
How would I access a range that corresponds to an entire column starting at row 2 (there is a header row)? The end of the selection should be the last non-empty cell in the column.
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Select an entire column minus header row in an Excel macro
Low Risk
See the Microsoft Support article How to select cells/ranges by using Visual Basic procedures in Excel, #19 (How to Select an Entire Range of Contiguous Cells in a Column).
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix