+ Reply to Thread
Results 1 to 2 of 2

Row-adding macro causing hidden row weirdness!

  1. #1
    Registered User
    Join Date
    07-31-2008
    Location
    Philadelphia, PA
    Posts
    40

    Row-adding macro causing hidden row weirdness!

    First of all, I've never done much with macros in Excel, but I've been authoring a macro that adds rows to my worksheet in specific places and then reformats their section so that they fit in properly. What I've found, however, is that when you use a macro to insert a new row, any hidden qualities below that row stick with the row name that was hidden, not with the row content.

    For instance, rows 19, 22, and 30 are hidden. I use a macro to insert a new row between rows 13 and 14. The aftermath is that the contents of rows 19, 22, and 30 all shift down to accomodate the new row, BUT the rows that are now hidden are the new rows 19, 22, and 30, with the content from the old rows 18, 21, and 29.

    So, what I need to know is: is there code I can add to my macro that lets it know that every time I add a line it should shift the hiddenness of every hidden row below that by one to accomodate? Sorry, still a macro newbie!

  2. #2
    Registered User
    Join Date
    07-31-2008
    Location
    Philadelphia, PA
    Posts
    40
    Nevermind. Strangely, it doesn't seem to be doing it now. I don't know what I did differently. Please disregard!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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