![]() |
Combine row insert subs
I've been trying in vain to adopt two of David McRitchie's subroutines to
one of the sheets in my workbook: From http://www.mvps.org/dmcritchie*/excel/insrtrow.htm Sub InsertRowsAndFillFormulas(Optional vRows As Long = 0) Sub InsertBefore_a_in_ColumnA() I've been able to do one or the other, but not both. The way my sheet is laid out, I have duplicate ranges in column A (except for the person's name in the first cell of those ranges), and every row ends with 2 columns containing formulas. Since there are bunches of them, I want a loop to find each instance of the word "wrap" in column A, insert a single blank row above (or below) it, but keep the formulas. Any help would save my remaining hair <g. -- David |
All times are GMT +1. The time now is 02:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com