Submitted by Richie Sills of Worcester, England. Richie is a tax manager at a firm of chartered accountants.
Application.ScreenUpdating = False With Worksheets("Sheet1") .Rows(1).Insert .Range("A1").Value = "dummy"