MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro to paste only formulas instead of contents from one worksheet to another


Posted by Kurt on September 02, 2000 6:45 PM

Hello,

I have tried creating a macro to record only formulas from one worksheet to another using the Paste Special, Formulas, but it doesn't appear to work.

Does anybody have a fix for this?

Thanks,

Kurt


Posted by Ivan Moala on September 04, 0100 2:00 AM

Thanks for that Kurt.....BUT our Labour weekend
is in October....long wait for a break ;-)

Ivan

Posted by Kurt on September 03, 0100 10:30 AM

Hello Ivan,

The code appears to work fine, I just wanted confirmation. It appears that this is a user oriented issue.

Thanks again. Have a great Labor Day Weekend.

Kurt

Posted by Ivan Moala on September 02, 0100 9:24 PM

I have tried creating a macro to record only formulas from one worksheet to another using the Paste Special, Formulas, but it doesn't appear to work. Does anybody have a fix for this? Thanks, Kurt

kurt
turning on the macro recorder should have given you something like this ??

Sub Macro2()
Selection.SpecialCells(xlCellTypeFormulas, 23).Select
Selection.Copy
Sheets("Sheet2").Select
Selection.PasteSpecial Paste:=xlFormulas
End Sub

Where is it not working ??


ivan