Save Worksheet Without Formulas (i.e. Values Only)

[hecgroups]

Hello Again,

I am trying to save a selected worksheet as individual workbook on my desktop. Till here the script is working fine but the problem here is is is saving with formulas although i need to save only values not formulas. i have highlighted the part below in my script.

Can any one help me please.

Please Login or Register  to view this content.

[tehneXus]

Please check the MS documentation on the copy functionality, as it seems to me that you are copying a sheet but pasting like a range: http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx

apart from that, the fastest was to convert a formula result into a value:

Please Login or Register  to view this content.

example for Activesheet Range A1:E5

[Alf]

To "extend" the solution proposed by tehneXus a bit one can also use

Please Login or Register  to view this content.

Alf

[hecgroups]

Thanks ALF it works. Just one question the activesheet the sheet which i am copying the values or the sheet which i am pasting the values.

[hecgroups]

Reputation added and topic marked as closed

[Alf]

Thanks for feed back and rep.

Please Login or Register  to view this content.

As you have marked the thread I assume you have solved the problem but just to be sure yes it's the same sheet.

Alf