hide rows

Hello: The following code was working for me, but, for some reason, it has stopped. Does anybody note any flaws?

I need a code to run through cells in a named range and remove the blank rows. I have one named range that actually refers to several smaller named ranges on separate parts of a sheet. Ideas?

Hopefully someone can help me with a problem I'm having with merged cells and a macro not getting on too well... On a sheet titled "Data", column A has a list of reference numbers. These are taken from column C on sheet one. Using "if(Sheet1!C5 = "","",Sheet1!C5), Cell A5 is populated...

Hi, I am trying to hide rows in sheet 4 of my workbook that don't contain the value of cell B4 in sheet 1. In cell B4 of sheet 1 in my workbook I will be manually entering a portfolio number. Sheet 4 contains a full list of all portfolios (558 rows). I am trying, thus far very unsuccessfully...

I am building a sheet as a building configuration guide for sales staff and customers. The customer is given the option of having several buildings next to each other, each with different options Cell B8 contains the number of side-by-side buildings the customer is asking for and is restricted...

Hi, All, I have a table that 20 items can change according to different conditions (years or quantity), but each year may not have all 20 items (Quantity might be 0). My ultimate goal is to generate a summary automatically from this table, but I don't know how to do so. I am thinking to repeat...

Hi, I found below formula in this forum that works really great on hiding all rows if it matches the string in any column of the row. However, I would like it to be reversed. Meaning, it will hide all rows that is NOT match to the string and also NOT blank (to avoid hiding rows of the entire...

Hi I am trying to do this myself, but cant get it work. First step: i ve created a list box made of months of the year. Second: I want only the month which already have been or at maximum the now that is now will show up Third: I made a OK button that will check the user choice and hide certain...

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 there, I am looking to develop a macro attached to a button for a rostering tool. When the button is clicked, the macro needs to consider whether there are any hours rostered (indicated by a numerical value in column C) OR whether there has been a manual override (a "Yes" in column A). If...

I have a list of 246 countries. I have 10 drop-down lists, allowing the user to select 10 different countries. I have assigned each country with the corresponding number they have in the drop-down list for ease of programming. After the selection has been made, the user will click on a...

Hello, Please can I ask for your help again. I am looking for VBA to Hide Rows (37:38), Based on value ("No") of a cell (D26) in another worksheet (Control Center). If cell D26 in worksheet "Control Center" is blank or "Yes", I do NOT want hide the row. Thanks, Tom

In the sheet1 all the cells of columns C to H are populated with data by a formula that get data from another sheet. The cell of the column G that corresponds to the current month is always blank. Which is the code to hide all the rows next to the row of that blank cell (e.g. rows 12 to 25 in...

Hi all, I am hoping someone can help me here...I have a fairly large spreadsheet (~12MB) which I am setting up a navigation tool to "scroll" between sections. This is done by a drop down and is linked to various other parameters and all works fine. However the issue is that it is quite slow and...

Hi All – </SPAN></SPAN> I’m hoping you can help correct this problem. I have a large workbook that will be delivered to several hundred users and requires many data entry fields, meaning the workbook and each of its worksheets need to be protected. On one of the worksheets, users of Excel 2007...

Hi everyone I'm new to VBA (which is to say I have no idea what I'm doing). I'm trying to create a macro that will hide empty rows on various worksheets when the workbook is opened. I have a similar piece of code that I've used successfully in another workbook: Private Sub Workbook_Open() Dim...

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

So I admit, this is probably way easier than I've made it out to be, but considering I've spent most of two days trying to figure this out and have yet to do so, I have arrived here, desperately hoping someone here will take pity on me and help me out. I have two sheets in a file called...

Okay, this is my first post AND I am not super-familiar with VBA/scripts. I know how to insert codes and that's about it. I work as a legal trainer, and usually am the one showing people how to do stuff. So, if you want to educate me within your response, that's better for me in the long run. If...