hide blank row

Can Excel Top Gun here help a rookie out and let me know if there are a better/faster way to perform the same action? This code works, but its slow and can take around 3-4 minutes on a laptop with i7 12th Gen processor & 64Gb RAM. The process is to hide the entire row if the respective cell in...

Hi there, I've tried a couple of different codes but can't quite pull it together. In Columns G15:G49 and H15:H49 I have formulas. If both cells in the columns equal zero (eg. G15 & H15), I would like to hide that row (row 15). If one is more than zero, it should be visible. If the data...

I am attempting to write excel VBA to hide blank rows across multiple worksheets based on cell value in Column A. Sheet 1 is where I use formulas to populate the rest of the sheets so this sheet will need to be excluded from the VBA. Sheet 2-5 are identical in terms of last names displayed and...

Hi, I want to hide the entire row in a pivot table in which the value(-s of that row is either zero, empty, or #NB. In the beginning of the year there wuill be o1 value in the pivot table (month=1). At the end of the year there will be 12 values in the pivot table (month=12). I want to solve...

I have been working on a very complex excel sheet for my job - used for estimating equipment, labor, and other costs for a services company. I have most of it working, but ran into an issue when I went to do a beta test. The bill of materials is quite long, and I have "collapse" and "expand"...

I am looking to hide rows if column B is blank using a pre-selected range of rows. I have several data blocks on a sheet that feed charts and as I copy/paste data into it, I select the range of rows then I plan on running this module using the pre-selected range (so I don't have to make a...

Hi guys, This is my first time actually posting here so here goes: The question is simple enough (I hope); I have a master spreadsheet that controls two slave spreadsheets. Layout-wise they are more or less identical, the columns are slightly different but the rows are exactly the same. The...

I am struggling to come up with a vba code that allows me to search column B, Rows 21:89 for blanks then hide/unhide the associated row. I would like it to be one macro so that I don't have to have two buttons on the sheet to hide/unhide.

I have this crazy project in Excel 2010 and I have one issue plaguing it right now. I've used Combo Boxes to allow a value to be selected in one of two spots - two combo boxes each pointing to the same data in a cell. On a summary page I've created, I've used VBA to hide rows that don't...

Hi, I'm looking to create a piece of VBA code that will hide rows if column B contains the number 0. My workbook has about 4000 rows. Thanks,

We have a spreadsheet that uses lookups for many fields including column F which will return either blank or "1". We would like to hide any row in which the value of Column F=1 I have found places this can be done in Visual Basic, but as neither myself or the other person who will likely...