hidden rows

  1. Q

    Making Conditional Formatting ignore hidden rows

    I have a document with multiple filters that cause multiple rows to be hidden. The visible data looks similar to this: <tbody> Column A Row 1 15 Row 3 24 Row 4 13 Row 5 32 Row 11 12 Row 13 20 </tbody> I am trying to create a conditional formatting to highlight the highest 3...
  2. W

    Ignore Zeros in Aggregate Average Function

    I get a feeling this might not be possible, but I have a table that uses the Aggregate function to average a column. It needs to be Aggregate, because that allows me to use slicers to see averages for different items in my table. The problem is, the Aggregate average is averaging the zeros and...
  3. R

    Hidden Object Range Failure in Worksheet Calculate

    I have a formula in Sheet2 named "Parameters" in cell D69. This formula is pulling info from sheet 3 & sheet 4. My excel keeps crashing with a Run-time error: Method 'Hidden' of object 'Range' failed. I don't see how it could be in a loop? In my sheet 2 - here is my vba code: Option...
  4. D

    Inserting blank rows between data, but ignoring hidden rows

    Good morning forum, I am tiring to insert blank rows between a range of rows, but need it to skip over hidden rows. Below is what I have started with and the inserting is working fine. Thanks in advance. Sub Insert_BlankRows() Dim MyRange As Range Dim iCounter As Long Set MyRange...
  5. A

    Excel Function in VBA hidden rows

    Hi everyone, I created a function in excel vba, saved it in the personal.xlsb, and it works exactly as I want it, the only problem is that it only works when I "unhide" the header row. I tried searching the problem but I couldn't find anything. Example Table <tbody> Header 1 Header 2...
  6. L

    Sum and subtotal filtered results for multiple sheets/rows/columns

    Hi all-- I have an extensive formula that works well, until I filter the results. Hope someone can give me some assistance in shortening the formula (if possible) as well as getting the filtered results. Here is a sample of the formula that I am currently using...
  7. D

    Pivot table filter rows hidden, can't get them to show

    Hi, I use a big pivot table with ~10,000 rows of data to make monthly individual reports for my colleagues. It's filtered with colleague name and Location, which indicates type of activity - two filter fields at the top left. Today I tried recording a macro to make the pivot in the hope of...
  8. J

    Muti select ListBox Very inconsistant when running code based on multiple selections

    Hello everybody. I have written a macro utilizing a Multi select ListBox and it is giving no errors. BUT it only works about a third of the time as intended. I have a listbox full of class names in one column and in the other column the corresponding class code. Example would be Class 1 - CL1...
  9. U

    Seemingly random rows of height 0

    Hi all, I've been working on a decently sized spreadsheet (110 columns x 500 rows) with a mix of text and numbers. I have formulas, filters, conditional formatting, etc being used throughout the sheet. My problem is this: I'll be working on the spreadsheet and tend to copy across information...
  10. F

    Need to make code faster: delete unfiltered/hidden rows

    So I found and manipulated code that Autofilters a specific column by criteria (if name is John) and finally deletes all of the other rows that don't have that name. Seems pretty easy but my code takes an entire 50 seconds to run which is wayyyy to long. Is there a way to rewrite this code...
  11. X

    Can COUNTIF exclude hidden cells

    Hi Folks, I'm hoping this will be an easy one. I am simply trying to count blank cells in a column but I would like to exclude the hidden rows if possible. The formula I'm using is =COUNTIF(E3:E63,""), very basic but it's picking up the hidden rows. Any help would be greatly appreciated.
  12. L

    How do exclude hidden Cells in my CountIfs formular

    Hi I have a spreadsheet whit a lot of data for en entire year. I need to count the amount of data within a specific date range and rows containing specific letter. The letters are in Coulumn G and there are a lot of different letter combination. I figured that it would be a lot easier to...
  13. L

    VBA code to hide a row does not work

    Hi All, I have a VBA code which does the following- * Hides a row if the values of column J and O are less than 12 It should look at row 3 and beyond. The VBA code is below, any ideas why it is not working? It does not come up with an error message or anything. The cells which it looks...
  14. E

    VBA - Hiding rows if other rows are hidden on different worksheets

    Hi All, I am looking to implement VBA code in my woorkbook whereby if a user hides / unhides any rows on Sheet 1 (for e.g. row 8), then the corresponding numbered row would automatically be hidden/shown on Sheet 2. By default all the rows are unhidden. I would appreciate any help! Thanks,
  15. 9tanstaafl9

    Can VBA copy and paste hidden rows and keep them hidden?

    I don't think this is possible, but I thought it wouldn't hurt to ask. I want to copy a large set of data where many random seeming rows have been hidden. I then want to paste that into several sheets and have those sheets look exactly like the original, with all the same rows hidden. I can't...
  16. T

    Get Array of Hidden Rows and Columns indices

    Is there a way to get an array of all the indices of the hidden rows and columns within a worksheet? I would like to do this without any looping, perhaps using Range.Find() if its possible or whatever is most efficient. Ideally I would like to have two functions (FindHiddenRows and...
  17. J

    Viewing comments in Excel 2013 causes rows to get hidden

    I am at least an intermediate Excel user, having used since the 1990s. I have a large worksheet containing many comments. In trying to go through the sheet and view them all with the objective of copying the information from each comment to a Word doc and then deleting all comments, I have used...
  18. S

    COUNTIF and SUMPRODUCT with AutoFilter possibility

    hi guys, first of all I am new in VBA! i have this worksheet as an example <tbody> A B C D E F G 1 person goods price % $ paid countif! 1/countif 2 X A 100 30% =D2*C2 =COUNTIF(B:B,B2:B2) =1/F2 3 Y A 100 20% =D3*C3 =COUNTIF(B:B,B3:B3) =1/F3 4 Z A 100 10% =D4*C4 =COUNTIF(B:B,B4:B4)...
  19. D

    Is there a way to have Excel add a row based off a drop down without using VBA?

    I am looking to have excel essentially unhide a row based off of a selection in a drop down box. The drop down box has multiple selections available and wanted to expose the proper row based on the drop down selection. Is this possible or does it need to be VBA? Thanks!
  20. H

    Drop down list

    Hi, I would like to have a list with values in range H:H, but only the rows that are visible (not hidden). Is that possible?

Some videos you may like

This Week's Hot Topics

Top