CODEWITHSUNDEEP
vbaexcelselect
KptKransch
KptKransch

Reputation: 23

Select EntireColumn from ActiveCell, except first 3 rows

I would like to select a complete column from an ActiveCell except the first 3 rows, because they are always filled with descriptions/headerlines. I know ActiveCell and EntireColumn, but i don't know how to combine the commands to come to a solution.

So I have 10 columns to be filled with data, and when the user wants to work on a specific column, i would love to have it so he just needs to click on any cell in the column and then my macro selects the rest.

Perhaps the entire column is not the best idea, since I need to add comments to EVERY cell and Excel does not like that. 1000 rows will do it.

Column select

Upvotes: 2

Views: 11655

Answers (1)

Darren Bartrup-Cook
Darren Bartrup-Cook

Reputation: 19782

Something like this code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    ActiveCell.EntireColumn.Resize(Rows.Count - 3).Offset(3).Select
End Sub

Upvotes: 2

Related Questions