Reply to thread

Message: [QUOTE="Robert Crandal, post: 13846996"] I am using the following code to insert a new row onto my spreadsheet: Rows("5:5").Select Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove This code will insert a new row above the current row number 5, which is okay. My problem is that the new row has the same height and possibly dimensions and formatting of row 4. Can I basically tell Excel to insert a row of cells that are a default size or a size of my specification?? I dont want Excel to insert a row of cells that are the same dimensions of the above or below row. I realize that I could write code to resize the new cells, but I am curious if Excel has a setting to stop it from copying the dimensions of adjacent cells. Thank you [/QUOTE]