I still don't understand what you want. Perhaps an example.

--
Don Guillett
SalesAid Software

"hans" wrote in message
...
I do not want to validate and calculate the date
In the row above are other calculations and validations i want to be
copied
automaticly

Hans

"Don Guillett" schreef in bericht
...
I think I would copy the cell above first and then enter the date to
validate and calculate.

--
Don Guillett
SalesAid Software

"hans" wrote in message
...
I want to copy the formulas and validation of the row above the cell i
changed, is this posible.

in other words
When i enter a date in collumn a (lastrow) (say this is row 10) i want
the
formulas and validations coppied from row 9

Greetings Hans