hidden columns

  1. F

    VBA or formula - Subtotal of Non-Hidden columns

    Hi, Have a report, totals represented in cells b3:ac3. I need to hide columns at times and would like the subtotals. I tried this thread but can't get it to work. Can anyone help? https://www.mrexcel.com/forum/excel-questions/655374-subtotal-column-hiding.html
  2. D

    Paste special code that ignores hidden cells

    Hello, I am after an upgrade to my simple paste special code. I want to allow the code to ignore hidden columns but I have no idea how to begin other than presuming that the code will be probably using an If statement and entirecolumn.hidden = true/false statement? But I get lost from there...
  3. H

    Multiple VBA codes - Only the one works

    Hi there. I am working on a task list at work for multiple teams and sites. I have written a vba for hiding columns depending on the team name. On a separate spreadsheet, I have a code that changes the font name of a cell to Wingdings to allow for a tick to be shown when a task is completed...
  4. SelinaR

    Macro to Hide column and another to unhide (WITH PASSWORD)

    Afternoon boffins... I have recorded a macro to hide and unhide a column, however I need to supercharge it... MACRO: On Sheet 2, to hide & another to unhide Column "U" 1. Hide column U 2. Unhide column U with a password... (hiding column & protecting the sheet wasn't a viable option) I would...
  5. C

    Hiding/ unhiding columns based on a data validation list on another sheet

    Hi all, I am trying to hide/ unhide columns based on a 'Yes' / 'No' data validation list on another sheet. The first sheet has a number of drop down lists, all with a yes/no outcome, I would like selected columns on a 'Tracker' sheet to be visible when the outcome is 'yes' and hidden when the...
  6. G

    Prevent deletion of data in hidden cells

    Hi Guys, I have a spreadsheet which has some columns that are a duplicate of the column before them (i.e. B1=A1 etc.) and other columns with formulas in them I am training someone else to run the report that uses this sheet and want to limit human error by automating as much of the data entry...
  7. andrewb90

    Add formula for only visible cells

    Hello all, I have this code that I am using to increase cell values based on another cells contents, however I would like not change my cell values if the column in Data1 is hidden. Sub add()Sheets("Score").Select Range("D3").Value = Range("D3") + Sheets("Data1").Range("C3")...
  8. O

    if any columns hidden then ask if want to unhide before saving

    Hi I've got a spreadsheet that several people use, some of them regularly hide columns to make it easier to look at while they work, the problem is the forget to unhide the columns once they're done, I've figured out how to stop this with a 'Workbook_BeforeSave' private sub that unhides all...
  9. E

    Adding alternate columns only if they visible

    Hi, I have data in a sheet which runs from column 'F' to column 'GU' over hundreds of rows. Every column (with headers on row 7) is alternatively named "Hours" and "Fees". Is there a way to have a total figure in columns 'GW' (for Hours) and 'GX' (for Fees) which adds up the respective Hours...
  10. I

    Hidden Columns Appearing on Smart Phones

    Hello Everyone! OK, I'm stumped. I have been generating and emailing password protected spreadsheets for years, hiding rows and columns that I don't necessarily want shared with everyone, with no trouble at all. Then all of a sudden, a few months ago I get word that hidden columns on one of my...
  11. T

    Get Array of Hidden Rows and Columns indices

    Is there a way to get an array of all the indices of the hidden rows and columns within a worksheet? I would like to do this without any looping, perhaps using Range.Find() if its possible or whatever is most efficient. Ideally I would like to have two functions (FindHiddenRows and...
  12. B

    Vlookup Ignoring Hidden Values

    Sometimes my data is hidden and I need to get the values. I don't know how to use SUBTOTAL with a VLOOKUP or IF statement, otherwise it would be easy. I'm trying to get only the visible scores for different players. <tbody> A B 1 Aaron 10 2 Bruce 20 3 Charlie 15 4 Aaron 25 5...
  13. S

    2003 charting - not allowing for multiple vertical axis option

    Howdy, I am trying to produce a chart including two columns of data and a column including corresponding dates. I am only able to view one column of data in the chart and excel is not giving me the option of plotting on a secondary axis. Why am I not being given the option to view data on a...
  14. D

    html showing hidden excel columns

    I have saved this same excel file several times before, with hidden columns, and they never showed up in browser before. Now all of a sudden when I save the same file after updating, the hidden columns show up in the html file! Argh, what has changed in IE that might be causing this?
  15. Z

    Printing - Specifically Column Borders

    I can't seem to find this elsewhere on this site though I'm SURE someone's asked: I print the same spreadsheet several times with different filters and hidden columns - and to that end "Custom Views" helps a TON. However when I hide a column it (obviously) changes the border style separating...
  16. L

    Hiding columns with 2 conditions / 2 row values

    I have a script i use to hide columns if the returning calculation= 'NR' and another similar script with I created if another cell = "0" to hide that column but the two cant run together- each script un-hides the previous script. (no matter what order they run in) Question: How do I join (or...
  17. J

    Using ScrollBar to hide groups of columns

    Hi all. I'm pretty new to the VBA game. I've got a large spreadsheet with many cells that need user input. A bunch of calculations are performed on subsequent worksheets, but I want the user to only see the fields they need to enter. I'm trying to write some code that will use a scrollbar (form...
  18. kskapin

    Using VBA to Hide and Unhide Columns with Click of Button

    Hello! I would like a button to be pressed that would hide specific columns. Once the button is pressed again, the columns appear. I'm extremely new to VBA, so I'm not sure of code syntax just yet. Private Sub CommandButton1_Click() Columns("D:G").Hidden , Columns("AF:AG").Hidden...
  19. A

    Pivot Chart Display Zero Value Columns

    I am using 2007. I have a set of data I am trying to display with a Pivot chart. I have a report filter for different departments and my horizontal data is dates, vertical is number of tickets opened per day. When i change the department, the dates when no ticket was opened goes away. I want...
  20. S

    Can't draw borders for hidden columns

    Hi all, I have a database and a few hidden columns and right now i'm using vba to insert new records via a userform. Whenever a new record is inserted via the userform i use codes to draw the borders. However, the hidden columns doesn't have the borders drawn when i unhide the columns. Any...

Some videos you may like

This Week's Hot Topics

Top