Related:
- Simple If else Loop with hide row
- How to hide app store on ipad - Guide
- How to know if someone hide their story from you on instagram - Guide
- Saints row 2 cheats - Guide
- Game loop - Download - Android emulators
- Platinum hide ip - Download - VPN
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.