hides

  1. S

    VBA - hide all rows unless column F contains specific text in cell

    Hi Lads, I have macro below which hides all rows and leaves all rows with text ''APPLE'' in F column on Sheet2, it works ok, but the problem is that in this table all cells are referrencing to different sheet i.e. ='Sheet1'!A1 which means Marco hides all rows not containing APPLE and all the...
  2. S

    hide rows based on a columns value

    Can anyone come up with formula that hides certain rows based on a column value?
  3. M

    Hide Rows Macro

    My macro hides all rows that have the number 3 in the first column. I would like to make it so that it hides rows that have 3,4 or 5. How would I do that here? Sub HideMaddie() BeginRow = 4 EndRow = 141 ChkCol = 1 For RowCnt =BeginRow To EndRow IfCells(RowCnt...
  4. G

    Grouping Select Columns using VBA

    <tbody> A B C D E F G H JAN FEB MAR APR ACT FCST BUDGET BUDGET X X </tbody> Hi All, I have question. I have a range of columns above. Each month uses two columns (Jan uses both columns A&B ex) How do I code the above to show only the columns...
  5. S

    "Secret santa"

    Can excel be used to randomize a secret Santa draw? It needs to have functionality that it randomises a name and wither emails that person or puts onto a tab or hides the name from everyone else.. maybe only access with a password so the host doesn't see who has who either?
  6. S

    Hide or Delete

    Hi, Curious if there is a way to hide or delete a row based on criteria? So if O3 says "Presented", then the whole row (3) either hides, deletes, or maybe moves to another tab. Is this possible? Thx
  7. Y

    Formula

    Hello, I have an excel file in which , cell G23 ( remaining dept fot year 2018 ) equals cell AJ22 ( unpaid depts Year 2019 ). What i need is a formula that hides the value in cell G23 if its not 2019 yet. Thanks in advance. Younan
  8. S

    AutoFilter using VBA (Hides every row that is blank)

    Wondering if I could get some help. I currently have the following code in VBA, the code works well but it hides all rows with anything that is blank. I'm using this with a search box and the column has around 3000 lines. Thanks Private Sub TextBox1_Change() ActiveSheet.Unprotect...
  9. B

    auto hide and unhide

    Hi guys I am trying to make a sheet unhide the row below when someone inputs a value in a certain cell. and if they delete that value the same row will got back to hidden. I have this code which hides the row but how to I make it hide the row if the value in the cell is deleted. Public Sub...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top