insert rows with formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jake - 01 Mar 2008 20:28 GMT

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

Reply to this Message

Dave D-C - 03 Mar 2008 01:38 GMT

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

>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
[quoted text clipped - 7 lines]
>thanks for any help,
>Jake

Reply to this Message

Rate this thread: