I have written some code which inserts a row into an excel spreadsheet and then copies various things, including formats, from the row above. * My thanks to other posters on the subject of row insertion.

Everything worked fine when I tested it. The problem arose when I went to use it for real - because the file is shared and, of course, I had removed the file from shared use when I was coding and testing.

I think the problem came in with the condtional formatting: as the existing rows in the worksheet have conditional formats.

How do I fix this problem? Do I need to remove the conditional formatting and write it into the VBA code? Or is there some way that I can tell excel to allow the row insertion and format copying?