Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Cells
i want a program to search through column A and when it hits the first value
of 9999, if will turn the RowHeight to 0 (starting at the next row) until it reaches the the next value of 9999 help please |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Cells
Hi lawson
Sub Example() Dim Firstrow As Long Dim Lastrow As Long Dim Lrow As Long Dim CalcMode As Long With Application CalcMode = .Calculation .Calculation = xlCalculationManual .ScreenUpdating = False End With Firstrow = ActiveSheet.UsedRange.Cells(1).Row Lastrow = ActiveSheet.UsedRange.Rows.Count + Firstrow - 1 With ActiveSheet .DisplayPageBreaks = False For Lrow = Lastrow To Firstrow Step -1 If IsError(.Cells(Lrow, "A").Value) Then 'Do nothing, This avoid a error if there is a error in the cell ElseIf .Cells(Lrow, "A").Value = "999" Then .Rows(Lrow).Hidden = True End If Next End With With Application .ScreenUpdating = True .Calculation = CalcMode End With End Sub My Add-in have this option Maybe you like it http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "lawson" wrote in message ... i want a program to search through column A and when it hits the first value of 9999, if will turn the RowHeight to 0 (starting at the next row) until it reaches the the next value of 9999 help please |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want to show/hide cells depending on other cells results | Excel Discussion (Misc queries) | |||
Cannot hide cells | New Users to Excel | |||
How do I create an IF function to hide cells in column B IF cells. | Excel Programming | |||
How do I create an IF function to hide cells in column B IF cells. | Excel Programming | |||
How do I create an IF function to hide cells in column B IF cells. | Excel Programming |