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!
Bookmarks