Thanks yogendra

What I'd like to be able to do, is where the user wants to insert a ro
between a series of rows, they select the row they want, then the
click a button and then that inserts a copy of that row below the on
they have clicked.

This copy would contain the same formatting, font size and colour et
and would contain the same formulas, but these formulas would hav
changed their cell references to reflect the new rows they are in.

Almost as if you'd simply grabbed the selected row and "copied down"


This code will do the "insert rows bit below" but doesn't copy all th
formatting and relative formauls I need it to

ActiveSheet.Unprotect Password:="xxxxx"
Selection.EntireRow.Insert shift:=xlDown
ActiveSheet.Protect Password:="xxxxx"

ANy ideas

--
Message posted from http://www.ExcelForum.com