Axolot Data

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!

Hello

Yes, there seems to be an error there.

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


Lars Arvidsson

Thanks, Larsa

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