hide rows

  1. S

    Hide rows or access only specific rows based on userform login

    I have a tricky question. I have a workbook I am using for a game about 1000 people will be playing. The workbook consists of several sheets but the only sheets users will have access to is a sheet called "Picks". Admin users will have access to all sheets so I already have a system in place...
  2. E

    How to hide rows in excel

    How to hide rows in excel
  3. tlc53

    VBA Code - Refer to Range and Rows

    Hi there, Can I refer to a range and row reference in one line of code? Eg. Case 0 Range("208:604").Rows("619, 629").EntireRow.Hidden = True So I would like to hide range "208:604" and single rows, 619 and 629. The above doesn't work. Thank you!
  4. B

    I Need Help with VBA Macros

    Hello, I'm pretty experienced with Excel and have been using it extensively for almost 2 decades now. However, my knowledge of VBA and Macros is very limited. I am looking for someone to help me with a few macros that will trigger when specific cells change to specific values withing a pretty...
  5. D

    Hidden Rows

    Hi there I wonder if someone could help me with a strange thing that's happening to a spreadsheet we use at work. I can't find anything in another thread about this. The spreadsheet is a database of staff and lots of columns of related data such as dates. It's used by 3 different people on a...
  6. A

    Auto hide rows

    Hello! Is there a way to automatically hide a row when specific data is entered into a cell in that row? At the moment i'm using the following: Sub HideNO() Dim cl As Range For Each cl In Range("AI14:AI900") If cl.Value = "No" Then cl.EntireRow.Hidden = True...
  7. A

    VBA help hiding rows

    Hello, I'm looking for a way to automatically hide rows based on cell data. The rows are 14-900, columns are A - AU and if the data in column AE reads "i. onboarded" I would like the whole row hidden. is this possible? Cheers,
  8. M

    Using VBA to automatically hide/unhide entire rows

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

    VBA/Macro Help- Hiding Rows Based on Cell Value

    Hello- I am trying to use a simple macro to hide rows based on the value of three different cells. The code tat I am currently using is below. The first portion works correctly, however when I copy it to use on the other required rows it doesn't work. Can someone please assist? I'm new to VBA...
  10. B

    Hide/Unhide Rows Based on Cell Value

    Hi All, First post here. I'm an experienced Excel user (former Lotus user) and just beginning to attempt some VBA. Most of what I've learned (which isn't much yet) has come from this board. At this point, what I know is pretty much limited to copy/paste of what seems a reasonable match and...
  11. J

    Hide / Unhide a Number of Rows Based on Value in Cell

    Hi guys, hope you can help me out here as I'm new to VBA. I'm trying to forecast tenant rent rolls for a property and have set for a max of 50 tenants. But based on a numerical value in a cell, which denotes how many tenants there are, I would like to hide the unused rows in the worksheet. E.g...
  12. N

    Hiding Rows With past Dates Automatically When Opening the Workbook

    Hi all, I want to hide rows based on a timestamp in column A. If the timestamp is a day old, hide the row. The code below used to work great but I just updated the workbook and the problem is that the code is only working for one of the worksheets (past date rows are hidden), while the other 4...
  13. H

    Delete Rows based on criteria

    Good afternoon, looking to remove some rows if cells equaled a certain text Rows 17-19 ~ AT11 = MS18 Rows 20-22 ~ AT12 = FB18 Rows 23-25 ~ AT13 = STS18 Rows 26-28 ~ AT14 = MH18 Rows 29-31 ~ AT15 = FS18 Rows 32-34 ~ AT16 = SFS18 Here is what I have researched thus far but it can only do one...
  14. A

    Hiding Row if a certain cell in that row is blank

    Hi All, I have a large budget spreadsheet where i have various codes ranging from A1-A50, however right now I only use about 15 of the codes but the other ones will be eventually populated. The description column uses an index match Formula which looks up a code list. What i want to do is hide...
  15. L

    Macro to hide unblank 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...
  16. F

    Macro isn't running correctly - hide rows

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

    Multiple Macro Buttons Hide/Show Specific Amount of Lines

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

    rows not hiding properly

    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" &...
  19. O

    Only show the row for today’s date and hide all other rows

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

    Hide two different sets of rows without macros based on different input criteria

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

Some videos you may like

This Week's Hot Topics

Top