VBA hidding columns baces on name rather than column number/letter

[zborton]

I currently have a user form with many check boxes to hide/show columns based on if a check box is checked or not. Right now I have the code refer to the columns based on thier letter and everything works great. I would like to have the code refer to the name of the columns rather than the letter to make everything more robust in case columns get deleted or moved around in the future.

Original working code:

Private Sub update_botton_Click()
'====================================================
'Update sheet based on checkbox selections
'====================================================

    With Sheets("sheet1")

        'Hides all the columns that steer are in
        Columns("ac:af").Hidden = Not (steer_cb)

Non-working idea of what I would like:
I have defined columns "ac:af" as the name "steer".

Private Sub update_botton_Click()
'====================================================
'Update sheet based on checkbox selections
'====================================================

    With Sheets("sheet1")

        'Hides all the columns that steer are in
        range("steer").Hidden = Not (steer_cb)

 

[Rick Rothstein]

Non-working idea of what I would like:
I have defined columns "ac:af" as the name "steer".

Private Sub update_botton_Click()
'====================================================
'Update sheet based on checkbox selections
'====================================================

    With Sheets("sheet1")

        'Hides all the columns that steer are in
        range("steer")[B][COLOR="#FF0000"].EntireColumn[/COLOR][/B].Hidden = Not (steer_cb)

[Untested] What happens if you add what I show in red above?

 

[zborton]

[Untested] What happens if you add what I show in red above?

That's what I was missing! thanks.