unhidden

  1. C

    Deleting row - does not disappear?

    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...
  2. G

    Unhide specified number of rows

    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...
  3. B

    Alter the formula for a cell

    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...
  4. S

    multiple worksheet change events

    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...
  5. S

    Hide rows automatically when another cell contains specific texts

    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"...
  6. N

    Macors to unhide cells

    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...
  7. L

    Average Unhidden Cells Only?

    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...
  8. 0

    Forcing Using of Button to Move Between Worksheets

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top