Inserting new rows VBA code

[CityMPLSEmpolyee]

I am looking at this code and trying to edit it for my needs. It currently inserts new rows into three sheets. Would only need it to work with one sheet, but as I try to edit it I get errors on the (Worksheets("Sheet" & lCt).Activate) code. How could I change this to work?

Please Login or Register  to view this content.

[JBeaucaire]

Simplest edit would be:

Please Login or Register  to view this content.

...or 2 or whatever you need. That would keep you from having to rewrite the whole macro.

[CityMPLSEmpolyee]

I'm sorry I should have noted that I'v tred that, but that why I noted that I am getting error on the code
Worksheets("Sheet" & lCt).Activate

so I will need to rewrite the code.

[Domski]

This will just work on the active worksheet:

Please Login or Register  to view this content.

Dom

[CityMPLSEmpolyee]

It work great in a simple workbook but when I add it in to my completed workbook it appears to only remove data that is not a function

[JBeaucaire]

Your original code is utilizing the xlConstants method, so the suggested solution used it, too.

If you want the entire row cleared regardless of the formulas in that row, change that line to:

Please Login or Register  to view this content.

[CityMPLSEmpolyee]

Now it appears to clear the entire row, still not making a new row.

[JBeaucaire]

I'll defer to Dom, I'm sure he'll respond soon.

[Domski]

I'll admit I modified the code but never tested it. Off home now and out tonight but will have a look when I get a chance.

Dom