View Single Post
Old 09-15-2019, 06:21 PM
Kenneth Hobson Kenneth Hobson is offline Windows 10 Office 2016
Advanced Beginner
Join Date: Jun 2018
Posts: 37
Kenneth Hobson is on a distinguished road

Mine selects a column for ctrl+space. It must be some application optional setting that does that.

Some people like both for a bullseye. Right click the sheet's tab, View Code, and paste.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Application.EnableEvents = False
    Union(Columns(Target.Column).EntireColumn, _
    Application.EnableEvents = True
End Sub
Reply With Quote