unhidden

Hi, Deleted a row and it only turned blank. Trying to delete it now but it does not disappear. Workbook or sheet not protected. All rows and columns are unhidden. No filters. No error messages. I believe it caused issues in the filter as well since almost all values are missing. What the hell...

Hi, I am very new to VBA, so please be gentle. I am looking for some code that will unhide a specified number of rows, dependant on a Cell value. For Example, If "B2" states 2, then 2 rows will become unhidden, starting from row 2 inclusive (2:3). If "B2" states 5, then 5 rows will become...

I have 6 cells that have certain data either in them or populates in them. The formula that I currently have for the total score (unhidden row 5) is =SUM(G228,I228,K228) The formula that I have for the total score (hidden row 6) is...

Hi there, I am trying to adjust excel so that when certain criteria is met, additional rows are unhidden. For example, when a number is entered, it unhides some rows (1 is entered 2 rows unhidden, 2 is entered four rows are unhidden etc). Once the rows are hidden, if a word is entered in a...

Excel version 2013 on windows. I have a spread sheet that I need to hide entire rows based on another cells contents. I need two rules, based on different conditions. Rule 1 When cell C14 contains "Select" I need Rows 20:34 to be hidden. When Cell C14 contains Anything other than "select"...

Good day, I am new to macros but a quick learner!! I have a row of cells 11:16 that I have hidden ... I would like to add some VBA to a command button so that when it is clicked it unhides 2 rows per click ... Click once: 11:12 unhidden click a second time: 13:14 unhidden 3rd time 15:16...

Hi all, I am currently working on a workbook that will serve as a low maintenance indicator for cross-functional KPI's at work. For this I have created a simple macro to filter by month so the charts only show performances from the selected month. This works by hiding cells in the spread sheet...

Excel 2007 - I currently have a sheet "Main" that contains many buttons for selecting reports, data entry userforms, etc. When the user selects one of these buttons the appropriate worksheet is unhidden and becomes the active worksheet. Each worksheet contains an "Exit" button with a macro to...