Question posted 2012 · +4 upvotes
How do I select the entire column after a specific cell?
For example, I would like to select the entire column after C24 so that includes C24, C25, ...
I have worked with the following snippet with no success:
ActiveSheet.Range("C24", ActiveSheet.Range("C24").End(xlDown)).Select
Could someone please correct my error?
Accepted answer +7 upvotes
You just need to wrap the two references within a Range:
Range(ActiveSheet.Range("C24"), ActiveSheet.Range("C24").End(xlDown)).Select
Top excel-vba Q&A (6)
- How to clear the entire array? +58 (2010)
- How to change Format of a Cell to Text using VBA +55 (2011)
- Download attachment from Outlook and Open in Excel +43 (2012)
- Can a VBA function in Excel return a range? +36 (2009)
- 2 Dimensional array from range +34 (2013)
- Hiding an Excel worksheet with VBA +33 (2009)
excel-vba solutions on this site
.