I've been inserting some rows in some sheets and everything is sound... Until I meet a chart! Charts in general are terrain I yet have to explore (and will be coming Monday)...
I insert a row like this:
.Range(.Cells(y, x), .Cells(y, x)).Copy
.Range(.Cells(y, x), .Cells(y, x)).Insert Shift:=xlDown, CopyOrigin:=True
Works like a charm, it keeps formatting and the dreaded merged cells where I need to keep them, but! Say it inserts 20 rows, but it encounters a chart, the rows keep getting inserted, but the chart isn't moved down accordingly!
Bookmarks