entirecolumn.hidden

  1. G

    Excel VBA: Why does EntireColumn.Hidden work only towards end of my code

    Hello, I'm using Excel 2013 and modified some code to help me filter a certain column, 7th column (the hub name), copy that filtered data, paste that to a new workbook, save it by the hub name being filtered, and format the new workbook. The code works. I'm just wondering why, however, I had...
  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