Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop learning
Hiding entire row, if value in cell in column B is Yes.
Private Sub CAT() Dim i As Long For i = 1 To 25 If Cells(i, 2).Value = "Yes" Then Rows(i).EntireRow.Hidden = True End If Next i End Sub Instead of using i = 1 to 25, can't I use the Count property? How would I do that? -- Howard |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop learning
Hi Howard
See the three delete macros on this page that use all a different loop http://www.rondebruin.nl/delete.htm The delete code start on the bottom and go up for hiding you can use both ways -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Howard" wrote in message ... Hiding entire row, if value in cell in column B is Yes. Private Sub CAT() Dim i As Long For i = 1 To 25 If Cells(i, 2).Value = "Yes" Then Rows(i).EntireRow.Hidden = True End If Next i End Sub Instead of using i = 1 to 25, can't I use the Count property? How would I do that? -- Howard |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop learning
Something like this:
Private Sub CAT() Dim i As Long For i = 1 To Activesheet.UsedRange.SpecialCells(xlCellTypeLastC ell).Row If Cells(i, 2).Value = "Yes" Then Rows(i).EntireRow.Hidden = True End If Next i End Sub "Howard" wrote: Hiding entire row, if value in cell in column B is Yes. Private Sub CAT() Dim i As Long For i = 1 To 25 If Cells(i, 2).Value = "Yes" Then Rows(i).EntireRow.Hidden = True End If Next i End Sub Instead of using i = 1 to 25, can't I use the Count property? How would I do that? -- Howard |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop learning
Thanks to both of you for advancing my limited knowledge!
-- Howard "Ron de Bruin" wrote: Hi Howard See the three delete macros on this page that use all a different loop http://www.rondebruin.nl/delete.htm The delete code start on the bottom and go up for hiding you can use both ways -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Howard" wrote in message ... Hiding entire row, if value in cell in column B is Yes. Private Sub CAT() Dim i As Long For i = 1 To 25 If Cells(i, 2).Value = "Yes" Then Rows(i).EntireRow.Hidden = True End If Next i End Sub Instead of using i = 1 to 25, can't I use the Count property? How would I do that? -- Howard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Learning VBA | Excel Programming | |||
Learning VBA | Excel Programming | |||
CDs and learning excel | Charts and Charting in Excel | |||
Just learning VBA.. | Excel Programming | |||
Learning VBA | Excel Programming |