I have an excel workbook (workbook 1)that i collect data in and run an macro
to create a copy of 1 sheet and save it as a stand alone worksheet (workbook
2). I then email this workbook out but the size is considerable, I have been
told i can remove the formula's from the copied sheet (to help with size of
copied sheet) but so far cannot find an easy way.
Any help would be appreciated

Have you tried this:
Once the workbook has been selected to copy,
in the new workbook, select edit, paste special, then select values.
hth
;-)

"Liketoknow" wrote:

I have an excel workbook (workbook 1)that i collect data in and run an macro
to create a copy of 1 sheet and save it as a stand alone worksheet (workbook
2). I then email this workbook out but the size is considerable, I have been
told i can remove the formula's from the copied sheet (to help with size of
copied sheet) but so far cannot find an easy way.
Any help would be appreciated

Thanks for your reply....works like a charm

thanks again

"FloMM2" wrote:

Have you tried this:
Once the workbook has been selected to copy,
in the new workbook, select edit, paste special, then select values.
hth
;-)

"Liketoknow" wrote:

I have an excel workbook (workbook 1)that i collect data in and run an macro
to create a copy of 1 sheet and save it as a stand alone worksheet (workbook
2). I then email this workbook out but the size is considerable, I have been
told i can remove the formula's from the copied sheet (to help with size of
copied sheet) but so far cannot find an easy way.
Any help would be appreciated