hide columns

  1. U

    VBA Hide unwanted columns on multiple sheets or a workbook

    Hi guys can anyone help me create a VBA code to hiding unwanted columns not needed, i want to enter the specific column header only that I want to remain on the sheets, Sample: I want "Tea" (can be change anytime) to remain on all the sheets because this is a workbook, and the rest o the...
  2. U

    VBA: Hide Columns in multiple sheets using loop

    Hi All, I'm currently looking for ways on how I can hide columns in multiple tabs sheets. Hide Columns: A, C-E, H, K-P,V-Z Sheets to loop: Sheet1, Sheet1 (2), Sheet1 (3), Sheet1 (4), Sheet1 (5) and so on (example Sheet1 (6) Note: If sheet's doesn't exist, just skip. Any help would be greatly...
  3. S

    VBA to hide date columns based on user selection in drop-down list

    First post and desperate to stop wasting my time trying to piece together bits of what I need from different searches. I am pretty new to writing code and will admit I don't always understand every line of code I find when searching. I have a timesheet template with date values (properly...
  4. J

    ComboBox to Hide Columns

    Hello Gurus, I am currently having trouble making my ComboBox ActiveX hide and unhide columns based on range of text in a row. I did not have an issue with the formula when it used to be a dropdown, but when I tried to convert using the ComboBox, I am having issues. What I would like this...
  5. E

    Hide Column

    Kindly I need your help in this: I work in a glass industry. I have 12 processes in the plant (Cutting, Edging, Drilling...) These processes are put in Cells B16 --> B27 I did an excel file for my planning. Each order is a column in Excel (column C till Column ZZ) And for each order there's an...
  6. B

    I Need Help with VBA Macros

    Hello, I'm pretty experienced with Excel and have been using it extensively for almost 2 decades now. However, my knowledge of VBA and Macros is very limited. I am looking for someone to help me with a few macros that will trigger when specific cells change to specific values withing a pretty...
  7. F

    Hide rows & columns based on range totals?

    Hello everyone, Excuse my ignorance but I found this macro, which works for hidding columns: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range("D7).Value = 0 Then Columns("D").EntireColumn.Hidden = True Else Columns("D").EntireColumn.Hidden = False...
  8. E

    What is this between the formula bar and the column headers?

    Hi there, I'm hoping that someone will just be able to take a quick look at this screenshot and tell me what it is I'm looking at. I've never seen it before, and it has just cropped up on a template I came across. I've used an orange rectangle to indicate what I'm looking at. From toggling...
  9. T

    WARNING!!! Watch out folks I just lost hours of work time because I didn't know.....

    Hey Guys, Not trying to spam, but thought this information would be important, because I haven't found it anywhere else. The other day I created a worksheet that had some intense formulas in it. In an event to make things easier I hid the column that the formulas resided in. I have just now...
  10. J

    Hide Columns based on Value

    So I'm pretty new to VBA and I'm not entirely sure how to approach this. I'm working with an existing report and my boss doesn't want it transposed or changed from the current format. I have productivity metrics running down column B and C4:AO4 has the headers (names of different offices)...
  11. M

    Why is my code now working?

    So I have come up with this really simple code Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = Me.Range("I") Then If Sheet("CAPA").Cells("G9").Value = "" Then Target.Hidden = True Else Target.Hidden = False End If End If End Sub And It is not working, can anyone help me...
  12. S

    Hide columns that contain numbers

    Hi, I'm trying to create a macro that hides any columns that do not contain any numbers. for example: <tbody> Cat dog mouse 3 mouse 5 mouse 4 Fred x x x x x x x x x x x x x </tbody> Turns to: <tbody> mouse 3 mouse 5 mouse 4 x x x x x x x x x...
  13. K

    Hide columns based on value in cell

    Hi, I want to hide unhide columns based on the criteria given in the cell for eg: my cell a1 has programme life eg 5 years, so the columns for only five years should be visible and the rest of the columns, viz the rest 10 years, should be auto hidden. Thanks in advance......
  14. M

    Hiding Columns AND rows based on a cell value.

    I am building a sheet as a building configuration guide for sales staff and customers. The customer is given the option of having several buildings next to each other, each with different options Cell B8 contains the number of side-by-side buildings the customer is asking for and is restricted...
  15. F

    Showing/Hiding Columns on Sheet 2 based on data validation in Sheet 1

    Hi All, I'm new to VBA and could use some help. I have a data validation with Yes and No as the choices on sheet1 and based on the response would like to hide columns AJ:AW on sheet2. I have been digging around the forums for the last hour and haven't come across the answer yet. Can someone...
  16. J

    Hide Columns outside of date range

    Hi all, I'm after some help if you will. I have a single worksheet that has every day of the financial year (as from 17th June) on it starting in cell C5 through to Cell KD5 (being 31st March 2014). I am looking to only show data from today back 2 weeks so it will be a rolling 2 week period...
  17. M

    Code to hide rows accross multiple sheets based on cell content.

    I need the macro code to hide rows on several sheets at once based on their content. Like if cell contains letter "U" hide that row... this in several sheets. Thank You, Mauro
  18. R

    One-click hide / collapse of colums with intel?

    Hi Gurus, I was wondering if you know a way to click the header of a column (in row 2) and have Excel automatically hide all columns except for the whichever Column was clicked and also never hide Col-B? If clicked a 2nd time, I would like all to return to un-hidden as well. Thank you, RR :)
  19. P

    Help with Conditional HideIf

    Hello- I have searched the forum, but have not been able to find this exact question. Found a bunch of related questions, but wasn't talented enough to translate them to solve my problem. =) I would like to conditionally autohide columns in response to a changes in the value of a single...
  20. C

    Hide columns with VBA

    I have a .xlsx spreadsheet with 10 columns and 2 rows (A1:J10). If A1 is blank I want to hide columns A through J. If B1 is blank I want to hide columns B through J. If cell C1 is blank, I want to hide columns C through J etc. How do I write code such that once the columns are hidden, if the...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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