| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Rows
Hi,
I have a dropdown validation list. When I select an item from this list, the rows below will be populated using the HLOOKUP function. The HLOOKUP function brings the values from the other sheet. The records will be one to one thousand. And I have the formula upto 1000 rows. When item has just one value in it the other rows will have the value zero. I need to hide those rows which have the zero values. I could have use the Autofilter, but I need it when the item is selected from the dropdown list. So this could be done using VBA code. Please help Shail |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Group rows (or hide rows) like in MS Project | Excel Worksheet Functions | |||
| Macro code to hide rows and not calculate hidden rows | Excel Discussion (Misc queries) | |||
| Enabling option „Format rows“ to hide/unhide rows using VBA-code? | Excel Discussion (Misc queries) | |||
| cut rows without cutting hide rows | Excel Discussion (Misc queries) | |||
| Hide Rows - copy and paste only rows that show | Excel Worksheet Functions | |||
Threaded Mode
