Copy & Paste Visible Cells with Formulas
 

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

Exactly what procedures are you using?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"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

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

My procedures are GoTo Special, Visible Cells Only, Select; then, paste.
The trouble is that it's pasting the numbers are values. How do you get it
to paste with the formulas intact?

Thanks again.
Ricky

"RagDyer" wrote in message
...
Exactly what procedures are you using?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"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

"Ricky" wrote
My procedures are GoTo Special, Visible Cells Only, Select; then, paste.
The trouble is that it's pasting the numbers are values. How do you get
it
to paste with the formulas intact?

Try Copy Paste special formulas OK

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

My procedures are GoTo Special, Visible Cells Only, Select; then, paste.
The trouble is that it's pasting the numbers are values. How do you get it
to paste with the formulas intact?

Thanks again.
Ricky

"RagDyer" wrote in message
...
Exactly what procedures are you using?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"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