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:
Please try this attached fix.
The hotfix worked. Thanks!