Unhide One Row From Many Hidden Rows

Jun 7, 2007

I am trying to create a macro to unhide only a row at a time, from around 150 hidden rows altogether. It is basically to give the effect of adding extra rows to a "table" that a user could then input with new data (I have to do this way according to other set-up in the workbook), but this isn't very important to do with this question. When I do a Format<Row<Unhide from the Excel menu, it always unhides ALL of the hidden rows. I have fiddled around but can't seem to find a way to avoid this happening, all I want is for just one row to unhide. I thought it might depend what cell/s I had highlighted, but I haven't found a way that makes it work.

View 7 Replies


ADVERTISEMENT

Unhide Hidden Rows..

Sep 5, 2009

I have a worksheet with a macro as follows: ...

View 6 Replies View Related

Unhide Hidden Rows

Aug 21, 2007

I HID 4 rows using this help section. (Format - Hide)

Then, I modified several column widths simply by placing my curser at the top of the column and pulling it smaller or larger.
(I don't know if this did or did not cause my problem) which is simply that - I am now unable to find my hidden rows.

I know where they are supposed to be, but when I highlight them and click (Format - Unhide) nothing happens.

I tried (Find and Select - go to special) and no white bar shows up.

Can sombody please tell this frustrated Newby How to find the rows I just hid 1 hour ago?

If I posted in the wrong place, I appologise as I spent more time trying to figure out where and how to post than I did trying to solve my hidden row problem.

View 5 Replies View Related

Cannot Edit A Macro In A Hidden Workbook. Unhide The Workbook Using The Unhide Command?

Apr 23, 2009

using Excel 2007/Vista

when I go a new edit a macro, I get the message

"Cannot edit a macro in a hidden workbook. Unhide the workbook using the unhide command"

Where do I find the relevant "unhide command"?

View 9 Replies View Related

Unhide A Hidden Application

Jan 4, 2010

Already read some threads about how to hide and unhide an excel application.
I was able to hide my excel application, but, somehow I'm not ale to unhide it when I close my Form:

View 4 Replies View Related

Different Password To Unhide The Hidden Sheets.

Nov 22, 2008

I have 5 sheets, 3 of them are hidden, how can i put a 3 different password to unhide the hidden sheets.

View 6 Replies View Related

Can't Unhide Cells And Got Hidden Formulas?

Sep 3, 2009

I've unlocked it fine, revealed formulas etc, but it doesn't make sense so must be a hidden formula stopping people like me from unlocking the hidden treasures!!!!

At the moment it stops at column V and I can't get it to unhide any further???

Used the edit, go to, etc won't go.

Deleted all code in vb I can see or find

Tried clicking on all sheet and unhide

Nothing!?

View 9 Replies View Related

Select Range Of Columns And Unhide Any That Are Hidden

Dec 10, 2013

I have a macro that allows me to select a range of columns and unhide any that are hidden. I am on the sheet "Employees", but the action happens on the sheet "Enter". I can run this macro when I am on "Employees" and jumps top "Enter" and works exactly as I want it to.

Code:
Sheets("Enter").Select
Columns("B:T").Select
Selection.EntireColumn.Hidden = False
Range("M8") = Sheets("Employees").Range("B5")
Range("I7").Select

But when I try to run it as part of another macro that begins on "Employees", I get "Run-time error '1004': Select method of Range class failed", and Columns("B:T") is highlighted.

View 4 Replies View Related

Columns Appear To Be Hidden But Will Not Respond To Unhide Or Width Change

Oct 6, 2013

I have just been sent a strange file, which I have attached, on its only sheet columns "A" and "B" have data entered in them, but they are not visible. You can access them if you select column "C" and use the left arrow key, but all attempts at unhiding and changing the column width are fuitless.

I have tried selecting the ENTIRE sheet, then Home>Format>Unhide Columns but it does nothing I try selecting the entire sheet, then Home>Format>Column Width and setting it to something, like "20", but again it is fruitless.

I even tried using a macro in the "Immediate Window" to ask Excel whether the columns are hidden (by using "?Columns(1).Hidden" and it returned "False") then I used a similar macro ("Cells.EntireColumn.ColumnWidth = 12.75") and again - nothing! :O

View 3 Replies View Related

Unhide Specific Column From Hidden Range Of Columns?

Jan 19, 2003

find if there is a way to unhide in one step a specific column from hidden range of columns...

Assume columns D..H are hidden, now how can I unhide column G alone or column F alone and so on.

View 6 Replies View Related

Excel 2010 :: Delete Filtered Rows Without Deleting The Hidden Rows?

Sep 25, 2012

How do I delete filtered rows without deleting the hidden rows in excel 2010?

View 8 Replies View Related

Error In Filtering Table - Additional Rows Shown / Rows Hidden When Filter Removed

Mar 4, 2014

I have an excel file with a table in it. It contains 2051 records (attached). This is just a sample, the original file has around 30,000 rows.

When I start using filters, I run into problems:

Step 1: Filter by Unit, condition (e.g.) Unit_23
Excel shows in the status bar the following message: 437 of 2050 records found.

Step 2: If I scroll to the bottom of the table, the row numbers are colored in blue (normal for a filtered list) however the last row is not colored and it actually should not be shown since its unit is not what I filtered for (its unit is Unit_25)

Step 3: Clear the filter of Unit

Step 4: Sometimes (depending on what I filter for), one or more of the bottom rows are hidden!!!

Attachment 301726

View 4 Replies View Related

Count Rows Including Blanks Omitting Hidden Rows

Apr 18, 2013

I have data in B4:B55 and need a formula to return a count of rows, including rows that are blank. However, there are hidden rows that need to be omitted from the count.

View 1 Replies View Related

Unhide 2 Rows At A Time Starting With Rows 28 And 29?

Aug 20, 2014

I need to unhide 2 rows at a time starting with rows 28 and 29 IF cell N28:O28 > 0. I need this to be for rows 30 and 31 IF cell N30:O30 > 0, rows 32 and 33 IF cell N32:O32 > 0, rows 34 and 35 IF cell N34:O34 > 0, rows 36 and 37 IF cell N36:O36 > 0, rows 38 and 39 IF cell N38:O38 > 0, rows 40 and 41 IF cell N40:O40 > 0.

There is currently a formula in each of the selected cells that is why I was going for greater than zero.

View 1 Replies View Related

Vba To Unhide Rows, Print, And Rehide Rows

Feb 9, 2007

I am attempting unhide the same exact rows in multiple worksheets in Excel, Print the entire workbook, and then re-hide the same cells. As I am still learning VB i have been unsuccesfull. I have attached the code that I am using,

Sub Printdoc()
Dim sh As Worksheet

For Each sh In ThisWorkbook.Worksheets

With sh
Rows("105:116").Select
Range("A105").Activate
Selection.EntireRow.Hidden = False
.PrintOut
Rows("105:116").Select
Range("A105").Activate
Selection.EntireRow.Hidden = True
End With

Next sh

End Sub

View 6 Replies View Related

Hide / Unhide Certain Rows

Apr 3, 2014

I highlighted a selection of rows and clicked HIDE, now I want to unhide certain rows and when I highlight the rows above and below and right click - unhide nothing happens. I need to Unhide to find something.

View 2 Replies View Related

Unhide Rows When Printing

Nov 28, 2007

Is there a VB routine that can unhide rows when I print?

View 9 Replies View Related

Macro To Unhide All Rows

Sep 16, 2009

Is there an easy way to make a macro to unhide all rows? I can do this to unhide a certain range however different rows maybe he hidden and so a set range won't work.

View 2 Replies View Related

Unhide Rows In 2007

Jun 17, 2008

I have done a search and drew a blank on this one. Hopefully there is an easy answer otherwise I see this as a fundamental flaw in Excel 2007 (on top of the lost productivity from ribbon interface). In all previous versions on Excel it was possible to select the rows either side of a hidden range (i.e. including the hidden rows) and right-click, Unhide. In Excel 2007 only visible cells are selected so this method does not work.

Hovering the mouse pointer on the row headings at the point of the hidden rows, waiting for the cursor to change and then right-click, Unhide only unhides the row imediately above, NOT the entire range. It seems the only way to unhide the entire range is to enter an address in the Name Box (taking care only hidden cells included otherwise only the visible ones will actually be selected) and then Format > Row > Unhide or Format > Row Height

View 6 Replies View Related

Unhide Rows - Spreadsheet Not Protected

May 24, 2014

I've a few rows that are hidden, and I cannot unhide them using the unhide function. The spreadsheet is not protected. What can I do?

View 5 Replies View Related

Hide / Unhide Section Of Rows

Apr 3, 2014

I have a button that I want to hide/unhide a section of rows.

This is the code a have so far:

[Code] .....

So I've named a a section of rows "rngHideRows". I've tried to use the command .Range("rngHideRows").EntireRow.Hidden = True (and viariants of this) but nothing I try works.

View 7 Replies View Related

VBA Hide / Unhide Rows On Other Sheet?

Jun 18, 2014

code:

Private Sub Worksheet_Change(ByVal Target As Range)
With Sheets("Sheet2")
Select Case Target.Address(False, False)
Case "B12"[code].....

I need to change it so that it hides a range of rows, say (6:26) instead of adding a line of code for each of the rows from 6 to 26 that I want to hide

Also how can I go about hiding the same rows on 5 more sheets, can I add more sheetnames after "Sheet2"?

View 3 Replies View Related

Hide/unhide Rows With Zero Values

Jun 19, 2007

Need a macro which will hide rows having 0 values. On running once it will hide those rows having 0 values and on pressing second time it will unhide those hidden rows and so on.

View 14 Replies View Related

Hide Or Unhide Rows With Using Checkbox

Mar 7, 2009

I need to hide / unhide some rows in a sheet with the help of a activex checkbox... I want remove, let's say row 20:24 and row 34 with one checkbox.

View 6 Replies View Related

Hide, Unhide Rows And Count!?

Apr 2, 2009

I have a code that will hide all rows that have a "-" in Colum A, leaving me with the useful data.

However, this data is pulled from a front sheet that has data added to it.

What I would like my code to do is to relook at all the hidden cells, and if their value has changed from "-" to what ever the data may be then to unhide that row, displaying the data.

The code I'm using currently is: ....

View 10 Replies View Related

Hide/Unhide Rows From Name In List Box

Jan 11, 2010

I have a list box on a worksheet that contains the following names: field, vessel, pipe, structural. I would like to be able to unhide certain rows based
on the name shown in the list box. For example, if I choose field it would
unhide rows 3 thru 12, if i choose vessel it would unhide rows 13 thru 20, so on so forth. If nothing is choosen in the list box then rows stays hidden.

View 9 Replies View Related

Hide/unhide Rows Using Checkbox

Jan 20, 2010

i'm newbie here. i need to hide & unhide rows using checkbox in excel but i stuck. i write these simple code and it doesn't work at all. my bad..

View 2 Replies View Related

Unhide Rows In Multiple Sheets?

Oct 12, 2011

Is it possible to unhide a row in one sheet and the same line can be un hidden automatically ini 2 other sheets within the same workbook

View 1 Replies View Related

VBA - Hide / Unhide Multiple Rows

Oct 26, 2011

I have a workbook with multiple tabs. Each tab has about 600 rows. In each tab, I need to hide/unhide rows based on the value of a particular column in that row. For example,

Row1: 10,7.89,John,TRUE
Row2: 16,9.08,Ram,FALSE
Row3: 98,8.09,Joseph,FALSE
Row4: 76,1.23,Harry,TRUE

Using the 4th column (that has either TRUE or FALSE), I need to hide entire row. I am using a loop on the range and hiding each row. But it is taking about 4 minutes for each tab to loop through the 600 rows and hide/unhide the required rows. Is there a faster way to achieve this? Following is my code.

Sub Toggle_Rows()
Dim Cell As Range
Application.ScreenUpdating = False
For Each Cell In Range("D1:D600")
If UCase(Cell.Value) = "TRUE" Then
Cell.EntireRow.Hidden = Not Cell.EntireRow.Hidden
End If
Next
Application.ScreenUpdating = True
End Sub

View 1 Replies View Related

Hide / Unhide Rows With No Data

Sep 21, 2012

I think this is fairly straight forward but my limited VBA skills have me going round in circles. I would like to have a button that hides and unhides rows where Column L has blank values but only from row 80 to 200 only. I would also like the button text to change from "Hide rows" to "Unhide Rows".

From Row 80 to 100 hide rows where there is no value in column LButton should be clickable to hide rows and then clickable to unhidebutton text changes.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved