Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to hide rows in a range that have a certain value, withoutfiltering
Hi All,
How can I hide all rows in a range that have a certain value eg "93/94" and then hide those entire rows only. Sort of like Find all instances of the value then EntireRoe.Hide I don't want to use filtering as the spreadsheet is intricate and I think filter coding might upset the structure. Thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to hide rows in a range that have a certain value, without fil
There are many ways. you can run a loop on the column that would have these
values. So if the column were "D", then something like this maybe: Sub HideByValue() Dim LR as Long LR = Range("D" & Rows.Count).End(xlUp).Row For i = 1 to LR If cells(i, "D") = "93/94" Then Rows(i).EntireRow.Hidden = True Else Rows(i).EntireRow.Hidden = False Next i End Sub That should get you going in the right direction. -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. " wrote: Hi All, How can I hide all rows in a range that have a certain value eg "93/94" and then hide those entire rows only. Sort of like Find all instances of the value then EntireRoe.Hide I don't want to use filtering as the spreadsheet is intricate and I think filter coding might upset the structure. Thank you |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to hide rows in a range that have a certain value, withoutfil
On May 22, 6:37*pm, JBeaucaire
wrote: There are many ways. *you can run a loop on the column that would have these values. So if the column were "D", then something like this maybe: Sub HideByValue() Dim LR as Long LR = Range("D" & Rows.Count).End(xlUp).Row For i = 1 to LR If cells(i, "D") = "93/94" Then Rows(i).EntireRow.Hidden = True Else Rows(i).EntireRow.Hidden = False Next i End Sub That should get you going in the right direction. -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. " wrote: Hi All, How can I hide all rows in a range that have a certain value eg "93/94" and then hide those entire rows only. Sort of like Find all instances of the value then EntireRoe.Hide *I don't want to use filtering as the spreadsheet is intricate and I think filter coding might upset the structure. Thank you- Hide quoted text - - Show quoted text - Thank you but rather than kind of looping using that or a For..Next I was looking for a way of finding all instances at once and then doing the hiding. But if needed will do the looping thank you Mark |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to hide rows in a range that have a certain value, without
There is no findALL. You have 3 methods to use
1) Use filter which doesn't hid. Then use specialcells to capture the visiable cells and hid them. Finally remove the filter using showall 2) Looping 3) Using find and findnext to located cells yo are looking for and then hidding these rows. " wrote: On May 22, 6:37 pm, JBeaucaire wrote: There are many ways. you can run a loop on the column that would have these values. So if the column were "D", then something like this maybe: Sub HideByValue() Dim LR as Long LR = Range("D" & Rows.Count).End(xlUp).Row For i = 1 to LR If cells(i, "D") = "93/94" Then Rows(i).EntireRow.Hidden = True Else Rows(i).EntireRow.Hidden = False Next i End Sub That should get you going in the right direction. -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. " wrote: Hi All, How can I hide all rows in a range that have a certain value eg "93/94" and then hide those entire rows only. Sort of like Find all instances of the value then EntireRoe.Hide I don't want to use filtering as the spreadsheet is intricate and I think filter coding might upset the structure. Thank you- Hide quoted text - - Show quoted text - Thank you but rather than kind of looping using that or a For..Next I was looking for a way of finding all instances at once and then doing the hiding. But if needed will do the looping thank you Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide rows within range if B? = X | Excel Programming | |||
Code for Excel 2007 to hide rows based on sum of several rows not ina range | Excel Programming | |||
Hide rows within a range IF... | Excel Programming | |||
Hide all rows within a range except one? | Excel Discussion (Misc queries) | |||
Hide blank rows in a range | Excel Programming |