Program to insert rows

[jfoerch]

Hey All,
I'm using the following code to insert rows into a spreadsheet...

Please Login or Register  to view this content.

rownumber and rowtotal are entered into a userform by the user. This works fine when regular rows are present. But, It goes crazy when I'm entering a row in the middle of a section where one of the cells in the row is merged.

I got the code by recording a macro where I inserted a single row at the same location that I'm testing (where the merged cell is present). Can someone help me understand what I'm doing wrong or if there is alternative code that I can use to get this done?

Thanks.

[Bernie Deitrick]

No need to loop - this worked with merged cells for me.

Replace your loop:

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

[jfoerch]

Perfect. Thanks. It didn't even cross my mind that the loop could be the problem. Thanks!!!

[Bernie Deitrick]

sorry, I should have been clearer: The loop was not the issue - the issue was with CopyOrigin:=xlFormatFromLeftOrAbove - it cannot merge cells - but you can copy and paste merged cells.