I have a spreadsheet called "Schedule Line 1", with a list of items that go from row 6 to 35. These rows have all formula. Some have values like 2436, 2440, etc and others they look empty, because the formula is zero, therefore, no value displayed. On a sheet within that workbook I created a formula to display these values. (eg.: =IF('Schedule Line 1'!AF9="","",'Schedule Line 1'!AF9). So it looks like this:

2369
2437
2440



2447
2422
etc...

Everything works fine.

Then, I copy these values into a different workbook and do paste special values with VBA.
I assume the blank cells between 2440 and 2447 must have values of zero, but they're not. I created a formula like =if(T24>0,1,0) and it returns 1. T24 is a blank spot between 2440 and 2447.

Any ideas why? How can I overcome this problem.