Macro for Pate Special Formula - Time Error 1004

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all, I would be delighted if anyone can help me with a macro to be able to
copy psate special formulas. I have tried to create the macro but I get the
error "run time error 1004", the code I have used on the macro is:
"
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
End Sub"
I have built this macro by first copying a cell with a formula, then I
started recording the macro following the steps: selecting a range of cells,
then paste steacial, then paste special, then formulas. Finally I stop
recording. What am I doing wrong guys?.
Thanks a lot for your help.
 
Hello "Unai".

Unai said:
Hi all, I would be delighted if anyone can help me with a macro to be
able to copy psate special formulas. I have tried to create the macro
but I get the error "run time error 1004", the code I have used on the
macro is:
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
End Sub
I have built this macro by first copying a cell with a formula, then
I started recording the macro following the steps: selecting a range
of cells, then paste steacial, then paste special, then formulas.
Finally I stop recording. What am I doing wrong guys?.
Thanks a lot for your help.
Click to expand...

That is an excel question but here is a newsgroup for microsoft access.
When opening the Tools, Macros... window, the "copy state" gets lost.
Define a shortcut or a new menu item that runs your macro.
 
Thanks for that Wolfgang and your are right I posted this in the access
group.regards.Unai
 
Back
Top