hidden cells

Please help! I'm running Excel 2002 on Windows XP at work and I'm making a spreadsheet that needs to be utilized by other coworkers (who happen to be less-than savy with Excel). I have numerous columns of formulas that I can "hide" so they are out of sight and don't confuse anyone. But when...

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...

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...

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...

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

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...

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...

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...

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...