entirerow.hidden

  1. C

    AutoHide a Row If All Cells in Range are blank

    Trying to figure out how to write code such that If ALL the cells in a range, say (B4:Z4), are blank then hide the row. I need this to be applied to multiple ranges however, not just that specific range. Idea is something like: Sub HideRows() For k = 4 To 40 IF All cells in Range...
  2. J

    EntireColumn.Hidden doesn't work in Worksheet_Change()

    Hi there, this is my first post as I've been tweaking and hunting for a couple of days and I haven't been able to find a resolution here or elsewhere. Using Excel 2010 I am editing an existing unprotected workbook and have created EntireColumn.Hidden and EntireRow.Hidden commands in the...
  3. A

    EntireRow.Hidden and EntireColumn.Hidden are misbehaving

    Hi, I've been encountering a problem with hiding EntireRow and EntireColumn. I've constructed a basic demo, the spreadsheet looks like this with 2 named ranges: My worksheet My code In my code I have two Subroutines, which loop through the named ranges and hide columns: Option...

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