| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Repetition of Code
I need to repeat the following code for rows 1 to 135. If the value of the
cell in Column G is false, I need to hide the whole row. Rather than type in masses of code, can anyone suggect some sort of loop to repeat 135 times. If Worksheets("Quote").Range("G1") = False Then Worksheets("Quote").Rows("1").Hidden = True End If Many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking up the value corresponding to the last repetition in a ran | Excel Worksheet Functions | |||
| Random number with no repetition? | Excel Discussion (Misc queries) | |||
| repetition cases | Excel Discussion (Misc queries) | |||
| PivotTable - Repetition of rows | Excel Discussion (Misc queries) | |||
| check for repetition of cell contents | Excel Worksheet Functions | |||
Threaded Mode
