>>Hi Hilmar.
>>
>>I thought I might have to do something like that... the only thing is that the Excel spreadsheet contains about 30,000 lines and there could be a no. of such formulae.
>>
>>I was hoping there might have been an easier way !!!
>
>Perhaps there is, I am not sure.
>
>Anyway, you could just select everything, and Copy & "Paste Special" into a new spreadsheet.
>
>If you need to do this once, it should be fairly quick to do it manually.
>
>If you need to do this on a regular basis, you should use Automation, to invoke it automatically from VFP.
Somewhere I have code for doing just this in automation ... email me if your interested Gerard.
Carole Shaw
Fred Hutchinson Cancer Research Center
Eagles may soar, but weasels don't get sucked into jet engines.