CopyColumns with cell value

Guest · Post by **Guest** » Wed Mar 28, 2007 5:22 pm

Hello!

I'd like to copy columns from one sheet to other with formula in cells but copy only value of formula.

I use 'CopyColumns(SrcSheet, Col1, Col2, DestSheet, DestCol: integer; DoCopyCells: boolean = True)' but unsuccessfully.
Please, help me.

Thanks!

Post by **larsa** » Thu Mar 29, 2007 4:22 pm

Hello

Yes, there seems to be an error there.

You can use CopyColumns first with DoCopyCells as False, the use CopyCells.

Lars Arvidsson

Guest · Post by **Guest** » Fri Mar 30, 2007 7:42 am

Thanks, Larsa

I copy first with DoCopyCells as False, then use CopyCells, but only formulas are copied instead of values of formula...