VBA. Array formula. Insert rows and copy formulae down.

[monkeypants]

Hi, hope you can help.

I have the following code which worked perfectly to insert 10 rows into a salary sheet when necessary.

I've since added an array formula into one of the columns and when you run the code, I get the error saying that you cant change part of any array.

I've tried different things but can't quite get it to work.

Thanks in anticipation.

[xlnitwit]

Hi,

You cannot manually insert a row within a multirow array formula either. You need to remove the array before you can do it either way.