Array Pasted from One Worksheet Converts Null Values to Zeros

B

BK Waas

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top