Paste special formulas wont work?

[T-rev]

i have multiple excel worksheets (12)

11 of which use data queries

1 for a master list.

the Master list is programmed with 4 VBA buttons, 1 to clear the list, 1 to extract the data from the other sheets making a new list, 1 to format the list, and the last 1 to add formulas (IF functions that produce TRUE/FALSE statements).

for some reason when i use the macro to copy my formulas from L3:Q3000 using paste special (formulas)

The result is False for every value.... The formulas are definately correct, and when i save the document and re-open they display the correct results.... Why is excel doing this?

Thanks in advance

T-rev - (Excel2007)

 

[AlphaFrog]

Cannot attach file.

You can paste data. See signature block below. Or a less popular solution is to upload a file to a free file share site and provide a link. However, some people in the forum wont download files.