+ Reply to Thread
Results 1 to 6 of 6

re mumber a list that contains hidden rows

  1. #1
    Forum Contributor
    Join Date
    03-02-2010
    Location
    Northumberland, England
    MS-Off Ver
    Excel 2016
    Posts
    143

    re mumber a list that contains hidden rows

    Hi,

    Is is possible to amend this macro to re-numbers a list when rows are hidden that are blank.

    Here is the code that I have that runs when the sheet is active. I would line a numbered list in column A starting at row 20 and ending at row 40, but when blank rows are hidden id like column A to be re-numbered 1,2,3 etc
    Please Login or Register  to view this content.
    Last edited by singerbatfink; 02-26-2015 at 05:08 PM.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: re mumber a list that contains hidden rows

    Maybe:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Contributor
    Join Date
    03-02-2010
    Location
    Northumberland, England
    MS-Off Ver
    Excel 2016
    Posts
    143

    Re: re mumber a list that contains hidden rows

    Thanks for the reply but tested the code and the numbered list appears in column B and over writes the formula I have in there. I want the numbered list in column A and the formula in B to be untouched.

    Thanks

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: re mumber a list that contains hidden rows

    That's weird try:

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    03-02-2010
    Location
    Northumberland, England
    MS-Off Ver
    Excel 2016
    Posts
    143

    Re: re mumber a list that contains hidden rows

    Wow, superb stuff xladept. Thank you so much.

  6. #6
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: re mumber a list that contains hidden rows

    And Singer,

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. ActiveCell.Rows(row number.Hidden returns false when row is hidden sometimes
    By Brandon2013 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2014, 04:08 PM
  2. Keep hidden rows hidden, in a protected, filtered worksheet
    By djp630 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-04-2014, 10:22 PM
  3. Replies: 2
    Last Post: 07-20-2006, 02:51 PM
  4. random mumber array
    By jedg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-31-2006, 10:43 AM
  5. [SOLVED] Re-Alphabetize list with hidden rows
    By Elaine in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-04-2005, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1