ok, i tried every possibilty, but it didn´t work. do you have any idea?
thanx

"Ron de Bruin" wrote:

You can use also value if you not want to copy formatting
with wsAS active try this

ws.Cells("B5").value = wsAS.Cells(ActiveCell.Row, 4).Value

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"raraschek" wrote in message ...
please, i need to copy a cell from a static worksheet, and paste it into a
concrete cell in a new generated worksheet. i´m trying to use something like
this, thanx for ideas.
wsAS.Cells(ActiveCell.Row, 4).Value = ws.Cells("B5").PasteSpecial