insert rows with formulas

  • Thread starter Thread starter Jake
  • Start date Start date
J

Jake

In Excel 2000 I would like the user to insert rows for data entry, but those
rows require functions. I don't know how many rows the user will need, but
shouldn't be more than 15. I've considered putting the formulas in and
hiding the rows and having the user unhide rows, but that seems a bit
awkward. Is there any method to manage this without programming? I've also
considered conditional formatting to format and make rows visible, but not
hidden, as required. I have about fifteen different sections on one sheet,
with up to 15 rows per section, so this method still requires all 15 rows to
be on screen, even if the user doesn't need them all.
thanks for any help,
Jake
 
You could have a right-click popup menu=commandbar
with a button connected to this:

Sub InsertRow(pRow&)
Rows(pRow + 1).Insert
Rows(pRow).Copy Rows(pRow + 1)
End Sub

but this will copy data as well as formulas.
You could change this to copy only formulas (formulae?).
Dave D-C
 
Back
Top