Menu
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?
650
Select the letter at the top to select the entire column. Or click on any cell in the column and then press Ctrl + Space. Select the row number to select the entire row. Or click on any cell in the row and then press Shift + Space.
Actually there is a Fill command on Excel Ribbon to help you apply formula to an entire column or row quickly. Firstly enter the formula =(A1*3+8)/5 into the Cell C1 (the first cell of column where you will enter the same formula), secondly select the entire Column C, and then click Home > Fill > Down.
How to reference an entire column or row in Excel. When you are working with an Excel worksheet that has a variable number of rows, you may want to refer to all of the cells within a specific column. To reference the whole column, just type a column letter twice and a colon in between, for example A:A.
If your list does not contain any blank cells, you can use the shortcut to select entire column but the first row. Select the header or the first row of your list and press Shift + Ctrl + ↓(the drop down button), then the list has been selected except the first row.
You just need to wrap the two references within a Range:
Range(ActiveSheet.Range("C24"), ActiveSheet.Range("C24").End(xlDown)).Select
Here's an approach that will work even if there are cells with content below C24:
With ActiveSheet
.Range(.Range("C24"), .Range("C" & .Rows.Count)).Select
End With
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
