Consulting

Results 1 to 2 of 2

Thread: Hide current Roll based on Cell value

  1. #1

    Hide current Roll based on Cell value

    Hello ,

    i need help to make macro that is hiding each current roll based on cell value in column A.

    Thank you!

  2. #2
    VBAX Mentor 大灰狼1976's Avatar
    Joined
    Dec 2018
    Location
    SuZhou China
    Posts
    479
    Location
    Hi xaxaredbul!
    For a simple example as below:
    Sub aaa()
    Dim i&
    For i = 1 To 100
      If Cells(i, 1) = "abc" Then Rows(i).Hidden = True
    Next i
    End Sub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •