Hi Kenny,

I suggest you re-read my previous reply. When you paste a formula, the Excel evaluates the cell references that apply to the pasted
copy and calculates a new value. That new value may or may not be the same as the old one.

--
Cheers
macropod
[MVP - Microsoft Word]


"Kenny" wrote in message ...
No, when I rub my vb script that paste special formulas only it pastes values
as well

"macropod" wrote:

Hi Kenny,

If, after copying you can still see formulae in the cells you've pasted into, then the values you're seeing are most likely the
results of the formulae re-calculating. The only exceptions to this would be if recalc is set to manual or the cells are
formatted
as text. If you're cells have formulae, you've got to expect something to be displayed (or a nul response if that's what the
expression evaluates to).

--
Cheers
macropod
[MVP - Microsoft Word]


"Kenny" wrote in message ...
I have a workbook called tracker that adds new records from a workbook called
data. When I add a new record I want to copy the formulas and formatting from
the row above and paste them into the empty row. Every time I try it copies
the values as well. please help