hide columns on macro

  1. The_Rock

    vba to Hide Columns based on User Input

    Hi Folks Can you help me with the following. In Column B, I have a list of countries. Cols C2:BB2, I have week number 1 to 52 (for 2013) Col BC is the Total for 2013. Cols BD2:DC2 are week numbers for 2014, again, numbered 1 to 52. DD is the total for 2014 What I would like is to have a macro...
  2. V

    Macro to eliminate columns that fail specific criteria

    Hello MrExcel users: I need a macro that will hide or delete all columns in a data set where the variation within that column is less than 20. For example, the macro would turn this dataset (which is in the format I will be using): <TBODY> Pos1 Pos2 Pos3 Pos4 Pos5 Pos6 Pos7 Pos8 Pos9 Pos10...
  3. StanAalbers

    Hide a column when cell 12 that row is empty

    Hello there, I have browsed the forum, but haven't found an answer yet for my challenge: I have a sheet where the data starts in row 12. Whenever the value in that cell (a12, b12, c12, and so forth) is zero, I would like the column to be hidden. I would like to have it in VBA, since this...
  4. D

    Code to hide columns isn't working

    I am having trouble with some vba code to hide columns. I need to hide column L:M and also O:AC. Whenever I run the macro it ends up hiding column N which has to be shown. I don't know whats wrong with it. Could someone help? I am using Excel 2007. This seems so basic yet I don't know why...
  5. R

    VBA to hide 3 columns hides all of them instead

    Hi everyone, this is my first post here so I hope you can help :) Here is the code I have so far: Sub Update() Columns("H:J").Select Selection.EntireColumn.Hidden = False Range("H7").Select Selection.AutoFill Destination:=Range("H7:H306"), Type:=xlFillDefault...
  6. E

    Macro to Hide Columns based on Multiple Selection (Drop-down Box)

    Here is my situation, I need to hide Columns based on Multiple Selected Criteria from Combo Box as follows: ComboBox is in A1, (ComboBox Contains 15 Counties from which I can select as many as needed). Every column contains one county name or multiple counties names in the same cell and across...

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