auto select column B

Av8tordude

Well-known Member
Joined
Oct 13, 2007
Messages
934
Can someone assist in a vba code that will automatically select column B of the same row the cursor select box.

example.. If I select G15, automatically select B15.

Thank you for your help
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Try this: right click the sheet tab, select View Code and paste in

Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.EnableEvents = False
Cells(Target.Row, 2).Select
Application.EnableEvents = True
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,108,787
Messages
5,524,870
Members
409,607
Latest member
charleswaynemc

This Week's Hot Topics

Top