I'm working with a large multi-sheet workbook and need to expand the formulas
on many sheets from Row 2 to a variable number of rows. Can someone offer
vba code that will allow me to prompt for the variable and then expand the
formulas to the specific number of rows accordingly?

I'm trying to keep my spreadsheet lean and don't want to have 750 rows of
formulas sitting there mostly unused. Sometimes, I'll only have 5 rows of
data and
other times 750.

My knowledge of vba is second grade so any documentation in the code itself
indicating what's going on is most encouraging. Thanks!