unhide rows

Hi, Currently I have a code which unhides the row below if cell J45 is populated. However, I would like it to unhide a block of rows. So instead of just unhiding 1 row below, it unhides 21 rows below (rows 46:66). Is there anyway to amend this code to do that? Private Sub...

I am looking to construct a VBA that unhides specific rows across different sheets in a workbook. I can write separate VBA for each sheet/row combination, but was wondering if I can put them all together instead? 3 sheets need the same rows unhidden that I already have code for: Sub Test()...

Hi all, I am currently making a spreadsheet that needs to hide 30 rows when a certain condition has been met. Does anyone know how to design a macro that can automatically hide/unhide 30 rows (rows 45 to 75) in the first specific worksheet "Sheet 1". The condition that will be met is when...

Hello, I'm trying to create a selection tool when based on the criteria selected more rows become un-hidden. So far I have the below for my code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'For On Property' If Range("C7").Value = "YES" And Range("F7").Value = "NO" Then...

Hello, I am a real novice to VBA but am trying to learn. I would like to include a macro in my spreadsheets that automatically unhide the rows below, one by one, if there is a value in the row above. eg if a date is entered in B11, row 12 is revealed when the user goes across to cell C11. The...

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

Sorry while I'm fairly good with excel formulas my VBA is rubbish. I am only capable of recording macros and that's it. I have what I know will be a very simple macro for someone on this forum - but despite my best efforts and hours (litterally) of searching I am unable to get the code right...

Hello Everyone! I need some help with VBA to auto hide rows (5:36666) based on any data is within a row or not. Auto hide if no data is located in A5:M3666. Then, if data is updated within a pivot table, then those rows hidden will auto reappear!!! Thanks for any help...

I want to be able show a prompt to add in the password before being able to do the actions below. Private SubToggleButton2_Click() If ToggleButton2Then ActiveSheet.UnprotectPassword ToggleButton2.ForeColor = RGB(0, 0, 0) ToggleButton2.Font.Bold = False ToggleButton2.Caption...

I have tried finding code for hiding rows from range with value criteria, with applying it to multiple protected sheets. Could someone help build the right code.Original code as following (i'll explain what i would need after the code): Sub CreatePDF_ERIKHONOKRISSEPETE() sheetname =...

Hi All, I am currently using a macro script within my workbook to un-hide hidden rows which I got from here thank you to Rick Rothstein!! It works really well until I try to protect my work sheet and then execute the script. Here is a copy of the exact code I am using Private Sub...

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

Hello, I have a macro running to hide/unhide certain columns depending on a user's selection in the drop down menu(s). I then unlocked the drop-down menu cells and protected the sheet. When I do so, the following error shows up: Run-time error '1004": Unable to set the Hidden property of the...

I'm creating a brief doc and I have most of the "if this, then thats" but one section won't unhide cells - ref. B26. The code above and below is working (ref. B23 & B39) - I have tried the bulk code as shown below and separated, but neither seem to work. Ideally, I would prefer that the code was...

Hi all: I have the following code which works beautifully for all the cells in the Range, except I need to add the following condition: For every Row in Range e19:22 whose Value equals the row above it, Hide the Row. (This should not affect the other rows in the C Column Range list). The...

I have a Summary Sheet that pulls data from various cells in other worksheets with the Indirect Function. But some of that info placed in the Summary Sheet is necessary repeated (would take too long to explain). What I need is explained in the title, but I need the first instance to remain. For...

Hi team, Please can you help me with the following scenario. I have a calculated cell (D13) which can either be (All), Grade or Rate. If D13 = (All), I would like Rows 19:52 to be hidden If D13 = Grade, Only Rows 19:20 to be hidden If D13 = Rate, Only Rows 22:52 to be hidden Thank you as...

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

Ok, I have searched the forum, tried using Excel Help but just can't quite figure it out. What I have created is a project management timeline spreadsheet. what i want to do is use a toggle button to hide and unhide any rows that do not contain any information in column A. sometimes not all...

I had a post for border color and I realize this one is similar, but I didn't realize that on my sheet because the user is zoomed out so far it is useless changing the border color property and linking a macro to it and it is much easier (user wise) to link it to the background color. The coding...