unhide row

I need to show the following and I can not figure this out! Scenario 1 I have row 10 filled with data up to column O I have rows 11-24 hidden This 15 row set up is copied down 50 times so the below process would need to be repeated in each of those 15 row sets If column O has a value >0 than I...

Dear All, I am trying to hide/unhide rows 14:17 in my workbook, but no matter what kind of coding I insert and modify in VBA, nothing works. What I have so far: Object X combo box (which I want to keep!) (drop down menu) between E:10 - J:10 which generates value/numbers 1-11 in cell F:10...

I have been trying to teach myself this through various forum threads but I have never used macros before so i'm not having any success. I have a data range on sheet2 from A2:C16 and if any of the values in column C return a value of 0 I want to hide that row. If that value changes then I want...

Hello, Thank you to all who help out on the forum... You make me much smarter than i am. :laugh: I am working on a sheet and am stuck with some VBA coding. As the title says i am looking to hide and unhide rows based on cell values. I am currently using a "extractwordinstring" formula to...

Hi, I have a very large excel worksheet. It contains a summary sheet, with 1-500 in column A. As I receive information for "1", I create a separate sheet, called "1". The summary sheet then pulls in some of the information from sheet "1" to A1/B1/C1, etc. All of the rows in column A that I...

Ok... I hid the headers to perform vlookup using different workbooks. The only way to do this (that I know) is to view both workbooks through View -> Vertical. Now I cannot unhide after I performed my lookup. Why and how can I get the "unhide" option again?

Hi!! I have a spreadsheet that has rows 10-500 hidden. I am trying to create a macro that when run will unhide 10 rows at a time. So when it is run the first time rows 10-20 will be visable, then when run a second time rows 21-30 will be visable and so on. Can anyone help with how this code...

Hi Everyone, I have this macro that is working perfectly, the only problem is that it takes very long time when a lot of rows are empty. I would like someone to help me modify it to make it faster. I have a report with information form A3:P103, when a cell from column B3 is empty the entire...