hi,
i created a macro to copy specified columns from 1 report (rpt1) to another (rpt2).
my problem is when i paste the value over, the format doesn't follow as well.
may i know the syntax to format a column or cell to currency format?
i've searched through the user guide but can't fiind any idea. please help. thanks!