hide rows

Hi, I am very new to VBA. Yes I know it's 2013 but I'm seeing the value in it for the first time. Everything I did prior to this was child's play, not that this is complex to most of you all. I'm looking to see if there is a way to hide rows and columns via VBA in excel. Cell b1 contains a...

I am new to Macros and am having a bit of a hard time with two issues. I am using Excel 2010 and am working on a spreadsheet. The first problem I am having is trying to write a Macro in VBA that will hide a particular row of cells given a criteria. Cell U3 is my reference and contains a...

I wrote the below script, but it is not working as I intended. I would like to view a certain range based on the text in cell A1. However, if i change the value more than once, a number of rows are hidden instead of the expected range. Any help would be greatly appreciated. Thanks. Private Sub...

Hi, I am writing a VBA code to restructure the multilevel BOM dump taken out from SAP. In this data the number of coloumn's are fixed and row numbers are dynamic depending upon the size of BOM data I have finished with my code, except one part where i am stuck. I tried various things but its...

Hello, I need help with a code that will search each cell across 4 columns and hide the row only if all cells are blank. The macro should search columns "b", "c", "e", and "f" to display all rows where at least one of the cells has a value. Ex. Col.B Col.C Col.D...

Help!! I have a rather complex (to me) scenario which I just cannot work out the best way to deal with this... any suggestions or samples would be really appreciated!! I have a workbook with two worksheets, Sheet1 and Sheet 2. Based on the data entered in the 2nd column on Sheet1, I'd like a...

Hi, I am new to vba. I am preparing an excel sheet which has option button. When selecting and unselecting that option button, the assigned cell value show True or False respectively. if the particular cell value is false, I want to hide 3 rows whose range is dynamic. That means, the rows...

I am new at VBA, so I will try my best to ask the question in the best manor. I am building a real estate model. What I am trying to do is the following: If I enter the number of tenants in a cell (let's say the number of tenants is 6 and the cell I enter this number in is cell J11), I would...

Hello, I require a macro to hide entire rows based on the criteria of having blank values in BOTH columns C & D. Thanks in advance BENR

Hi there, I have a data file ranging from B8 until AI77 (headers from B7:AI7), in case each cell in a row is zero or blank (e.g. B8=C8=D8=E8:AI8= 0) the row needs to be hidden. A sum function cannot be used, since I have both positive and negative values in the cells. Furthermore, columns H...

Hello, I would like to hide certain rows in a range of cells using an If statement. Here's the scenario... In the Column "A", I would like to place a "*" in a cell to indicate that I would like that row to be hidden, then run a VBA code that says "if there's a "*" in that cell, hide that...

I am trying to run a macro but only want it to execute if the text matches. here is what I am currently using: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address(False, False) = "B2" Then If Len(Target.Value) >= 2 And Len(Target.Value) <= 2 Then...

I would like to hide rows for data that does not meet specific criteria. For example: If a user selects room number 101 from a drop down in B1, I want to filter data in range A3:F1000 to show me only room 101 rows (A column) where C column contains a value larger than zero OR D column contains...

I am new to posting here, so please pardon any newbie statements or questions! So, I have seen several recommendations for VBA code to Hide Rows with VB based on a cell value, but it seems that none are exactly what I am looking for, any help would be greatly appreciated. On our spreadsheet...

OK - don't use excel much more than the standard functions, but I do have a fairly robust to-do list that has data associated with it. What I am trying to do is creating a button (or link - does not need to be fancy) that I can put in to each row that will invoke the row-hide function. I also...

Hello, I've written a macro that is supposed to hide/unhide rows based on a cell's value. I want it to run the macro whenever a certain cell is clicked, so the macro re-runs if the value of the specified cell is changed. When I go to the cell and change the value, nothing happens. The case...

I have a worksheet where the value in the cells B9 and B10 are entered manually. I would like to set up a code where Rows 20 to 25 show up based on the values entered in these cells. Cell B9 can only have the value of 4 or 6. Cell B10 can have the value of anywhere from 0 to 60. Here's what I...

I found this in your archive: Posted by Jacob on December 28, 2001 6:38 PM Hi With formatting you cant do this. With VB you can. Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) If Target.Value = 1 Then Rows(Target.Row).RowHeight = 0 Else End If End Sub...

Hello there, Apologies for posting this question when I see that similar questions have been posted elsewhere. Unfortunately, my knowledge of VB is very limited and I haven't been able to get the (seemingly very clear) responses to those other questions to work. I have a spreadsheet that is...

Hi everybody. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> Thanks so much already for all of your help. I have no clue about macros whatsoever but with the help of this forum I was able to mount quite a nice form in excel already. I just...