CopyRow() method crashes when OFFSET function present

Laurence,

If a row contains a formula with the OFFSET function and that row is copied elsewhere, the CopyRow() method throws an “object reference” error. Try copying a row with the following formula:

=SUM(A1:OFFSET(A3,-2,))

Thanks,
Natan

Please try this attached fix.

The hotfix worked. Thanks!