In one workbook, I have two worksheets: Project Status and Project Schedule.

The first three columns of worksheet "Project Schedule" are columns A,B, and
C. These are pasted as an array {='Project Schedule'!A:C} into worksheet
"Project Status".

The problem is this: Cells that contain null values in columns A, B, and C
of worksheet "Project Schedule" generate values of zero when they're
reproduced in columns A, B, and C of worksheet "Project Status".

Why does the array in worksheet "Project Status" convert null values into
zero values, and how can I prevent this?

Thank you in advance.