Copy & Paste Visible Cells with Formulas

[Ricky]

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

 

[RagDyer]

Exactly what procedures are you using?
--


Regards,

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

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

 

[Max]

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

 

[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

 

[Max]

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

 

[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