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

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top