DynamicFill

Fills in more rows at end of a range
Used to add more rows at end to have all formulas, formats and borders for nRows more.
sRange is expected to be 1 row, like B5:P5
Needs functions ColumnName and CutString to work
as usual, caller can customize sheet, workbook and count of rows to fill down.


Public

Tested

My Own Work

Optional nRows = 50, Optional FillOffset = 1, Optional sRange = "A1:B1", Optional WB = "This", Optional Shee = "Active"

Views 2 Downloads 0