I have this piece of codear and val both return numeric values but the last string of my code returns "run-time error '1004': Application-defined or object-defined error.ar = ActiveCell.Row val = Application.WorksheetFunction.CountIf(Sheets("AB").Range("B:B"), ActiveCell.Value) Rows("val:ar").EntireRow.Insert shift:=xlDown
Any ideeas? tnx.
Bookmarks