Try:

Select the filtered range

Press F5 Special Visible cells only OK
(this'll select the visible cells only)

then

Right-click to copy paste special formulas OK

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Ricky" wrote in message
...
Hello Experts,
When I paste the visible cells, all of my numbers are pasted as values.
How
do I paste visible cells and keep the formulas?

Thanks in advance,
Ricky