hidden rows

Good Evening, I saw a recent post on this subject, but it doesn't address my situation specifically. I have a table that is linked to an Access database, and I'm trying to calculate percentiles using the AGGREGATE function. There are also zeros that I do not want to include in the percentile...

So I'm writing some VBA code so that when certain things happen certain shapes change to different colors. Example 1 is a shape-changing color based on if a sheet is visable or not: If ThisWorkbook.Sheets("FlashForge").Visible = True Then ThisWorkbook.Sheets("Farm...

Hi everyone, I don't know much about VBA, but I am trying to hide rows on multiple sheets without having to go through each sheet and run the macro. Here is my code: Sub HideRows() Dim cell As Range For Each cell In Range("A1:A30") If UCase(cell.Value) = "NO" Then cell.EntireRow.Hidden = True...

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

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

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

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

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

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

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

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

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

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

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.

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

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

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,

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

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

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