hide / unhide columns

  1. J

    Hide Columns - if they contain cells which are coloured

    Hello , I have a spreadsheet that contains many columns of data that contain a range of cells that either Yes or No Set up a conditional formatting so the YES cells are coloured and the No's are not. I can do this either way round. I was wondering if someone knows of some code to hide the...
  2. N

    Hide a Column in All Worksheets when Opening the Workbook

    I'd like to hide column "B" for all worksheets and set the Row height to 15 for all worksheets when I open the workbook. I tried a For Next Loop but I'm encountering run-time errors. Here's the code: Sub Workbook_Open() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets...
    • nryan
    • Thread
    • hide / unhide columns hide / unhide rows
    • Replies: 1
    • Forum: Excel Questions
  3. B

    Hidden Columns Still Have a Width > 0

    Hi, I am new and I have searched for a solution to this problem for a few hours. I couldn't find any questions that directly addressed my issue, so here it goes: I am working on a macro that involves many steps of formatting for one worksheet. Much of that work involves hiding rows and...
  4. C

    Run-time error '1004' - Macro for Hiding/Unhiding Columns

    I am trying to create macros to toggle between different views for an excel worksheet but keep getting "Run-time error '1004": Unable to set the Hidden property of the Range class. My goal is to use the same set of code but change the ranges for the hidden columns and unhidden columns. Below is...

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