bryce Professional

  • Member since Apr 24th 2006
  • Last Activity:
Posts
1,195
Reactions Received
1
Points
6,136
Profile Hits
706
Search Content

  • Hi Bryce, I just joined the group. in 2017 I found a post where you gave this code;

    1. Sub hideColumns()
    2. Dim ws As Worksheet
    3. Dim rng As Range
    5. Application.ScreenUpdating = False
    6. Set ws = Sheet1
    8. For Each rng In ws.Range("A58:ADO58")
    9. If rng.Value = "" Then
    10. rng.EntireColumn.Hidden = True
    11. End If
    12. Next rng
    14. End Sub

    What I would like to do is to have the user click on a cell in column A select the entire row and use that as the range, instead of the fixed range.


    I apologize if this isn't the correct place to post this as this is my first time.


    Adrian