Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide unbolded rows in specific column
How would I write the code to hide only rows that do not have bolded items
in column K ... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide unbolded rows in specific column
For i = 1 To Cells(Rows.Count,"K").End(xlUp).Row
Rows(i).Hidden < Cells(i,"K").Font.Bold Next i -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Annette" wrote in message ... How would I write the code to hide only rows that do not have bolded items in column K ... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide unbolded rows in specific column
Sub HideNotBold()
Dim ColK As Range 'find last row of data in column k plus 1 Dim lngLastRowk As Long lngLastRowk = Range("k65536").End(xlUp).Rows Set ColK = Range("k1:k" & lngLastRowk + 1) 'check each cell value For Each c In ColK If c.Font.Bold = True Then c.EntireRow.Hidden = True End If Next c End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide rows if nil result of formula in specific column | Excel Discussion (Misc queries) | |||
Hide data in specific rows/colums/cells in Excel 2003 | Excel Discussion (Misc queries) | |||
how to create a formula to hide specific rows after meeting requi | New Users to Excel | |||
Hide all rows where one specific cell in that row = 0? | Excel Discussion (Misc queries) | |||
hide rows with specific contents | Excel Programming |