Past Special changes results for macros... how to prevent this
 

I have the problem that I have a formula in a cell that copies dates
and values from others cells into these cells..

The macros that use i.e. isdate wont work on the cells with the formula
so I used paste special to copy values back into the cell.

It looks like now they only have the date but the macro doesnt
recognice it ...

What am I doing wrong?

Matt

Past Special changes results for macros... how to prevent this
 

never mind .. fixed it :)