Target.Calculate to Me.Calculate breaks Copy/Paste

I just checked if there were any differences in the Visual Basic codes between the sheets, and it seems there is another sheet with the same VB-code that has the same problem:

The code is used to auto-refresh a conditional formatting that highlights an entire row on selection of a cell.

The 2 sheets with this code suffer from the problem:

Please Login or Register  to view this content.

And the other sheets use this code:

Please Login or Register  to view this content.

Not sure if I'm better off now to post this question in the VB part of the forum?!

Ok, since I had some more info to go on, I stumbled on this thread which confirms the copy/paste loss.

No solution is given though.

The reason I use the Me.Calculate on those 2 forms is because I'm using some Array formula that spit out an error if I select them with Target.Calculate active.

Basically, this code:

Please Login or Register  to view this content.

On a sheet with this Conditional Formatting:

Formula:

Please Login or Register  to view this content.

gives a VB runtime error 1045 when selecting a cell with this array formula:

Formula:

Please Login or Register  to view this content.

To avoid that problem I was suggested to use this VB-code instead:

Please Login or Register  to view this content.

Which has caused the copy/paste function to stop working.

As a workaround to avoid the runtime error with the Target.Calculate code I have copied the array formula to a helper column and referenced the cells that I want to display the data in to that column.

That's all I can provide for now, so I hope someone more knowledgeable knows a better way around it.