View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt[_33_] Matt[_33_] is offline
external usenet poster
 
Posts: 78
Default 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