bryce Professional

  • Member since Apr 24th 2006
  • Last Activity:
Posts
1,195
Reactions Received
1
Points
6,136
Profile Hits
666
  • 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
    4. Application.ScreenUpdating = False
    5. Set ws = Sheet1
    6. For Each rng In ws.Range("A58:ADO58")
    7. If rng.Value = "" Then
    8. rng.EntireColumn.Hidden = True
    9. End If
    10. Next rng
    11. 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