Macro to save sheet only

[JohnDoh]

Hi again,

One more today, Im trying to improve a wookbook i use quite often.

It uses the macro below to save a copy of itself which is fine, but I would like to change it to only export one sheet called "Quotation" and if possible save only number/text values for the whole sheet apart from the formula's in cells F11:41, I11:41 & N11:41 though I don't know if this is even possible.

Please Login or Register  to view this content.

[HaHoBe]

Hi, JohnDoh,

for the saving maybe try

Please Login or Register  to view this content.

Ciao,
Holger

[Jakobshavn]

Immediate before the SaveAs statement, put a Call to this sub:

Please Login or Register  to view this content.

[JohnDoh]

I cant seem to get the above to work

Also after reviewing the idea it would appear that in reality I need to keep all the formulas except those that refer to another sheet.

Attached is an example to see if that makes it clearer, in the Quotation Tab, cells which refer to another sheet in the formula are colored red all other cells with formulas are colored yellow.

Though after speaking to HaHoBe I fear I might be flogging a dead horse.

savesheet.xlsm

[HaHoBe]

Hi, JohnDoe,

maybe like this:

Please Login or Register  to view this content.

When testing I received a couple of #NA in the area Column I so that maybe the workeheet should be copied in the workbook itself, worked on and then exported.

Ciao,
Holger

[JohnDoh]

Holger,

Thank you for your help and patience.

Now have it working.

Regards,

Adam