copy/paste special formula to new workbook

[tourbud]

Hello, this is my first post.

I have a question that may have been answered before, but i didn't see it.

I have a speadsheet that i need to copy some data and some formulas from it to a new workbook. When i am recording the macro and use the paste special/ column widths the thing works perfectly. But later when i run the macro it only copies the values. it doesn't copy the formulas.

I have tried changing my macro in VB so that it copy/paste special formulas to the new workbook but that doesn't work either.

What I am trying to accomplish is i am making a "estimator" which has some drop downs for picking options. when all the options are picked and the "estimate" is completed i want to copy the quote to a new document and return to the "estimator" and reset itself for another quote. The result I am trying to achieve is that the new workbook will have basic sum formulas included in it, so if a price is changed i don't have to put in the formula again.

 

[stnkynts]

It probably has to do with how you were pasting while recording the macro.

Could you submit your code so we can see why it may not be pasting the formulas. Don't forget to use CODE tags.

 

[tourbud]

i am not sure what code tags are?

but here is the part of the code which i think is relevent. (not sure)

Selection.Copy
Sheets.Add After:=Sheets(Sheets.Count)
ActiveSheet.Name = ("quote")
Selection.PasteSpecial Paste:=8, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
ActiveSheet.Paste
Sheets("quote").Select
Application.CutCopyMode = False
Sheets("quote").Move

first i move my estimate with the paste special column width "8" to a fresh sheet, rename the sheet and move to a new book.

 

[tourbud]

nevermind, i found a different way to do it.

i just resized my columns before hand, and did a paste special, all format formula. and it worked.

thanks for looking though.