Related:
- Simple If else Loop with hide row
- How to know if someone hide their story from you on instagram - Guide
- How to hide app store on ipad - Guide
- Fruit loop studio - Download - Musical production
- Platinum hide ip - Download - VPN
- Saints row 2 cheats - Guide
3 responses
Ivan-hoe
Posts
433
Registration date
Saturday February 16, 2008
Status
Member
Last seen
October 17, 2008
110
Sep 26, 2008 at 02:55 AM
Sep 26, 2008 at 02:55 AM
Hello,
here is a solution in a kit form. Dare ask if you need more help.
Ivan
Use a "For Each...Next" loop :
The "if" statement would be :
Then, to hide a row, have a look at "Range.EntireRow" and "Range.Hidden" in the help file.
To make your code run faster, think of using "Application.ScreenUpdating" (see help file)
If you want your macro to run automatically when you change the selection in B1, see the help file about the events of a worksheet.
here is a solution in a kit form. Dare ask if you need more help.
Ivan
Use a "For Each...Next" loop :
Dim MyCell As Range, MyRange As Range
Set MyRange = Range("C3:C450")
For Each MyCell In MyRange
'instructions
Next MyCell
The "if" statement would be :
If MyCell.Value <> Range("B1").Value Then
'instructions
End If
Then, to hide a row, have a look at "Range.EntireRow" and "Range.Hidden" in the help file.
To make your code run faster, think of using "Application.ScreenUpdating" (see help file)
If you want your macro to run automatically when you change the selection in B1, see the help file about the events of a worksheet.
