Unhiding Rows

    I have a worksheet that will not allow the unhiding of any rows. A row can be hidden OK, and the row counters will show the correct row numbers, ie., 105, 106, 108, 109, etc., with 107 being the hidden row. However, subsequently selecting rows 106 and 108 and clicking "unhide" will not result in row 107 appearing on the sheet, and nothing I can do will make it reappear. Am I doing anything stupid (not an unlikely event, unfortunately)?


    Any help would be much appreciated as this is causing a real problem.

    Re: Unhiding Rows


    OK, I did that (holding the shift key while selecting), and it made no difference. Any hidden row on this particular woorksheet remains stubbornly hidden.

    Re: Unhiding Rows


    Do you have any code in the workbook?


    Software: OpenOffice 3.0/NeoOffice 3.0 on Mac OS X 10.5.6
    Humanware: Older than dirt


    Old, slow, and confused - but at least I'm inconsistent!


    Rich
    (retired Excel 2003 user, 3.28.2008)

    Re: Unhiding Rows


    No, there is no code. There are quite a few formulae (IF, etc.), but basically the workbook represents a very basic use of Excel. Nothing at all fancy.

    Re: Unhiding Rows


    I think I've found at least part of the problem. The workbook sheet in question has been sorted, and then the filter feature that removes duplicate entries has been invoked. It looks like this sort of screws up the row numbering, and prevents any unhiding after the rows have been hidden. Will have to do a bit of thinking on how to get around this. Anyway, thanks for the help that has been posted.....

    Re: Unhiding Rows


    Do you mean that you have Filter on the selection? Then un-apply the Filter (Data > Filter > Autofilter). Or have I misunderstood you?


    Software: OpenOffice 3.0/NeoOffice 3.0 on Mac OS X 10.5.6
    Humanware: Older than dirt


    Old, slow, and confused - but at least I'm inconsistent!


    Rich
    (retired Excel 2003 user, 3.28.2008)

    Selecting Rows Based On Date Within 14 Day Period


    SELECTING ROWS BASED ON DATE WITHIN 14 DAY PERIOD
    Selecting Rows Based On Date Within 14 Day Period


    --------------------------------------------------------------------------------


    I need some help
    SELECTING ROWS BASED ON DATE WITHIN 14 DAY PERIOD
    I have data from a calendar in my excel spreadsheet, I want to be able to select any date located in the first Column A, and then run a macro which will find the date 2 weeks ahead, copy the data in between and paste in a new sheet or new file.


    The problem is the date 2 weeks ahead must be a weekday, becasue weekend and holiday info is missing. If the date 14 days ahead is missing I want the macro to go to the previous day and try to find it, if it is also missing then go back 1 more day...until it find a date which is actually in the calendar data.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login