hidden cells

  1. W

    Hiding Rows in a Range of Cells with If Statement

    Hello, I would like to hide certain rows in a range of cells using an If statement. Here's the scenario... In the Column "A", I would like to place a "*" in a cell to indicate that I would like that row to be hidden, then run a VBA code that says "if there's a "*" in that cell, hide that...
  2. A

    Assigning a value from hidden cell

    I am attempting to run the following line of code: ActiveSheet.Range("AI18").Value = ActiveSheet.Range("A2").TextThe only catch is that both "AI18" and "A2" are hidden cells. When I run this code the values don't translate unless the reference cells are not hidden. Is there a workaround to...
  3. S

    Activecell.text on a Hidden Cell

    Got a bit of a strange one. Looping through a group of cells, and if the cell value is blank, I want to put a value in the cell (in this case, 0). Heres the problem. When the cells are visible, it works fine. When the cells are hidden, the activecell.text is equal to "". If I run the code...
  4. andrewb90

    Printing Hidden Cells

    I am sure this is pretty simple, but I am unsure how to do this. I would like to create a button to print out certain cells, most of which are hidden. How do I go about doing this? Thanks, Andrew
  5. C

    Hide or Group cells in Middle of spreadsheet

    Hi Im running excel 2010. I need to hide or group some cells in the middle of a spreadsheet to create a custom view of them hidden. I tried using the format cell>custom and using three semicolons (;;;) but this simply hides the contents and doesnt group the cells like it would if you hid the...
  6. S

    Problem counting only visible cells

    I have read the thread on how to count only visible cells with other criteria, but I don't understand how to generalize this to my situation. Here is the originial countif statement: =COUNTIF(Data!T:T,"*"&B3&"*") Here is the code that I have copied from previous threads, with my numbers...
  7. H

    Only visible cells copy when filters applied

    I have an Excel 2007 spreadsheet with several hidden columns, from which I copy and paste into another spreadsheet with the same structure. I want to copy the hidden cells so everything lines up on the new sheet. However, when I use Autofilter to select the rows I want, then highlight those rows...
  8. M

    Disable copy/paste of protected hidden cells?

    Hi, I have a similar problem to one mentioned here: http://www.mrexcel.com/forum/showthread.php?t=245549 I've drawled through the forum and haven't found an answer and wonder if there have been any developments. I'm using Excel 2003. I have a sheet with a range of rows hidden and then...

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top