Macro copying formula where i only want the values

[fakafan]

Hi there

I have the following macro which works fine accept for the fact that it copies the formulas from other worksheets, where as i only want to copy the values. Can someone please help?

Please Login or Register  to view this content.

[Olly]

Please use CODE tags when you post code...

Try changing to:

Please Login or Register  to view this content.

[fakafan]

Thanks for this.

I have tried this code and it is now only copying one field across, and not the 8 fields it was copying orginally. Am i doing something wrong?

Sorry this is the first time i have tried doing anything like this.

[fakafan]

ive updated my code and now it works for one worksheet, but i need it to do the same thing for each worksheet in the workbook....how can i do this?