hide rows

Hello. Requesting assistance to enter Macro which hides all rows containing data in any column. I'll be copy/pasting data in to rows A & B and want to run the macro after pasting so it hides the data and makes space for the next user to copy/paste the next set of results. I appreciate...

Hello guys I hope your doing well. I#m currently working on an excel file including 3 sheets. The first one includes Datas. The second one is called input and is a kind of form where 12 lists are placed. The user has the option to select between the different options. For example one Option is...

Hi, I'm fairly new to vb all on my own and have a small understanding of it. I'm in voice engineering so I'm trying to map a sales workbook/form to a hidden tab for building the telephone lines in the switch via .csv, so learning excel was something I didn't expect. I have read many posts...

Hello all, When this code runs, select rows are supposed to hide when the value of column F is TRUE, but I'm not sure why it's not working... Sub Hiderows()Application.ScreenUpdating = False Rows("4:10").Hidden = False For r = 4 To 10 If r <> 7 Then If Range("F" &...

Hi I would like to make my sheet only show the row for today’s date and hide all other rows? e.g 01.01.2016 02.01.2016 03.01.2016 04.01.2016 And if the date today is 02.01.2016, it will only load all the data on that row? This would also be for multiple people so there would be 5x todays...

The old thread here on Mr. Excel does mostly what I want to do: hide rows WITHOUT Macros in Excel. However, I want to do something a little more expansive. I know nothing about VBA, so I need a little help, as I tried to add multiple criteria to the code above and it didn't work. I have a...

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

Hello everyone, Excuse my ignorance but I found this macro, which works for hidding columns: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range("D7).Value = 0 Then Columns("D").EntireColumn.Hidden = True Else Columns("D").EntireColumn.Hidden = False...

Hello, I've been looking online to see what macro I can use for when: e.g. B8 = "New Zealand" and "Select" Hide Rows 22 and 23 otherwise keep it unhidden or If B8 = "Australia", unhidden Could anyone possibly help me? Thank you so kindly, It would be a huge help! Kind regards,

Hi all, I am working on an Excel 2010 workbook and am looking to create a worksheet.change event to hide specific rows if they are blank, or show them if they are not. I have a number of tables which use formulas to populate cells based on values elsewhere in the workbook, which means...

Hi: I am almost convinced that this cannot be accomplished or it would be difficult to accomplish. I would like to hide specific rows only when someone is filtering the data. I have several rows in my spreadsheet which I use for 'illustrative' purposes but if the user filters that data on any...

I have been trying to teach myself this through various forum threads but I have never used macros before so i'm not having any success. I have a data range on sheet2 from A2:C16 and if any of the values in column C return a value of 0 I want to hide that row. If that value changes then I want...

Hi All, Although this is my first post on here.. Thank You to the Forum as I've been following and learning on here for over a year now. As per my subject title, I have quite a few things I'm trying to work on and they are all linked to the Active X Combo Box. I'm running Windows 7 and Excel...

Looking for a VBA module that will hide all rows except adjacent rows that have "9" as their value in one cell of column B, and "5" in the cell below it, like this: Column B 1 9 5 18 23 3 11 5 9 4 9 5 22 So, in the above example, you'd hide all rows except the ones I've bolded for you here...

Good morning everyone. I'm stuck on using a code to hide rows using an active x checkbox. I'm still trying to understand VBA codes. I would like to show if check box is checked, all rows will be unhide. If it's not checked, it will only show rows that has a value in column B. This I what...

Hello everyone. I am quite new to this aspect of Excel and I have been surfing for quite some time on Google and on this forum, on the subject. My problem is that I can't find topic that is of use to me, with my level of knowledge on this field. My problem, is to me, quite simpel: I would...

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

Hello! First of all thanks for useful website. Need your help. I got spreadsheet with information in columns A to BL and In column "BK" on some rows i got message "closed" the rest within "BK" are with no text in it. I need macro to hide the columns that contains "Closed" and something that...

Hi all, I'm fairly new to VBA programming. Im actually creating a BOM (Bill of Material) in Excel, and I'm simply trying to hide the rows where the item quantity is 0 when clicking a command button. It looks like this: Private Sub CommandButton1_Click() If Worksheets("BOM").Range("D3").Value...

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