Fill down formula with start row and end row in column for specified worksheets

[Redled89]

The following code works for each sheet in the workbook as written, however, if the user inserts a row on a given worksheet the remaining worksheets formula within the column containing start and end row text shift down over the "Start1Note" end row/"Start2Note end row string.
Ie if one row is inserted all successive worksheets go from
Note1Start
Formula
Formula
Formula
Note1Start

To:

Note1Start
Formula
Formula
Formula
Formula


Any ideas to correct would be appreciated.

Please Login or Register  to view this content.

[AlphaFrog]

Not sure I follow, but the StartRow and EndRow lines are finding the rows on the Active sheet and not on each individual sheet. The Range("A:A") reference is missing a leading period to use the With sh qualifier.

Please Login or Register  to view this content.

[Redled89]

Thank you Alphafrog! Makes sense now why it was not working properly without leading period for sh qualifier. Much appreciated.