hide / unhide rows

I have written VBA code to hide specific ranges in 4 different tabs in my workbook. I am looking to add another range to the code that would hide rows based on cell value in the same range on each of the 4 different tabs. If the cell in range B9-B13 is blank, then hide that specific row on...

Hi everyone, I have a sheet with two blocks of data. On both blocks, I want to hide a different number of rows, using the following code. The thing is that VBA says I can't have two of the same. Is there a way to have one (or more) macro(s) have multiple Worksheet_SelectionChange(ByVal Target...

I want to find a way to automatically hide rows in Excel when any particular cell is 0 within a specified column. In the example below, after running the macro, the column on top would collapse and then it would look like the column on the bottom (since the cells with 0 would have their rows be...

In my Worksheet2, the data are generated based on formulas that reference to data in Worksheet1, and are formatted as a list (from A1 to AS100) like below: <tbody> A B C D E F ... AS 1 ID Code Property1 Property2 Property3 Property4 ... Property28 2 1 AAA 111 3 4 3 CCC...

I know I can combine more than one function on a button (as I have on each of these buttons), but I had no luck trying to combine the 2 buttons into 1. Seems like I should be able to do it with a "With" but I can't seem to make it work. I think it must have something to do with where I place the...

Hi, I'm new in VBA, I've been searching the internet to solve my problems in excel. I'm preparing a Payslip sheet which contains a Command Button which automatically prints all the payslips. The sheet contains salary benefits which other employees don't have. Let's say employee 1 is entitled to...

Greetings, Gurus: As you may know from my prior questions (and answers), I look and try for days before posting here, but I'm stumped. I'm working on an increasingly complex workbook, heavy on automation and VBA. On one sheet, I have created two "sections". The first section runs from Row 5...

Hello everyone! First off, I should start with a big, big thank you: I've spent a few days working on a template to create offers for my catering business, and this website has helped me SO MUCH! However, it seems that I can't make this one work, even by reading other posts: On the budget...

Hello, I'm using this BruceWayne code that works fine in the worksheet whith the command button. But, I want the macro to run in all sheets except were the command button is? Sub RowsToHide() Dim myVal As String Dim mainRow As Long, tweakRow As Long Dim hideRange As Range, showRange As Range...

Hello, I have a hide row on a calculate event which is partially working when it is above and below a given value. 1. H57 is a calculation with an error message =IFERROR(SUM(G41:G51,G54:G55)/SUM(E41:E51,E54:E55),"please complete all sections") 2. my code Private Sub Worksheet_Calculate() If...

Hi all, I have used Mr Excel several times and always found an answer or a lead to an answer. I now have a few months of experience with VB. So until now I managed by Googling and this is the first time I need to post a problem myself. Let's dig in: I have a fairly simple code (see below) on a...

Putting together a time-off request template with a "Submit" button (assigned macro that will confirm required data input, validate entries, calculate hours subtracting holidays/weekends, etc., email to supervisor, etc.) that is deleted after submission. I have hidden rows with supervisors...

Hi Team I want to make one spreadsheet where I want to Hide few rows permanently to other users. So if we have sheet with 10 rows, I want hide five rows permanently and 5 rows visible. also I want these five rows which are visible user can use filters. Regards Sagar

Hello all, I have been recently tasked with taking over a report someone else created and distributed to several individuals throughout the company. The person who created this made some macros that when a certain range of cells are double clicked one would hide all unused rows and the other...

Hi there! I'm new to VBA so please be gentle. In my Excel sheet I have dropdowns that range from G20 through Z20. I'd like to keep Row 21 hidden unless the word "Upgrade" appears anywhere in the range G20 to Z20, then i want Row 21 to be unhidden. If the user changes the dropdown and Upgrade...

Hello, I am very new to excel and need assistance in modifying a existing macro to also hide any rows within the same range with a value of 0.00 in column "C". Thanks in advance Here is my current macro: ' ' Sort Macro ' ' ActiveWorkbook.Worksheets("sheet1").Sort.SortFields.Clear...

Hello there, Looking for a bit of help at hiding rows in a sheet called "Summary" based on cell E35 in a sheet called "Basics". I can get this to work using the code below the problem is that I will want the value to go to 100 and up to 100 rows (from row 24 on) to be hidden. WI'd also like all...

Hej i have a workbook, with a frontpage of pivottable outputs in form of charts and tables, that are controlled by several Sliders, the pivot tables are on other sheets. my problem is that depending on the selection in the sliders, sometimes my table has a few lines of data and sometimes...

Hi all, I have workbook that I would like to automatically hide/unhide rows & columns based on values. I have 3 activation cells on a worksheet called "Capacity Requirements". D7: The value of that cell can be 1-7 and is intended to determine the term of the model (from 2016-2022). In row...

Hello, I have the following two macros which separately work but when I run one and then the next, they don't to build on top of each other and work in unison. running macro 2 undoes macro 1 and vice versa. Essentially what I need is: a) hide entire rows where individual row total = 0 (Macro...