hide columns

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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)...
  9. 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...
  10. 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...
  11. 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......
  12. 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...
  13. 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...
  14. 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...
  15. 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
  16. 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 :)
  17. 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...
  18. 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...
  19. 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...
  20. D

    How do I Unhide columns that are equal to a Drop Down/Cell Value?

    Hello everyone, I am pretty new to this whole Excel VBA, Macro business. I have a relatively large spreadsheet (couple hundred columns) and I am trying to make it easier to navigate / select what I am viewing. I am using Excel 2007 if that is important. This spreadsheet keeps track of contract...

Some videos you may like

This Week's Hot Topics

Top