Hi,

I'm trying to copy values from an original set of columns into a new set of
columns, where the column order is different.
Can I replicate copy_paste values functionality with something as below?

mystartcellnewset.cells(i,j).formula = mystartcelloldset.cells(i,k).value

I've tried different combinations of .formula, .text, .value, and the above
gives the best results, but I still get things like number of employees ("5 -
10") converted to date, and phonenumber text converted to a number without
leading 0 etc.

copy_paste values in a double loop (column, row) seems very inefficient, so
I'd like to do this in a single simple statement...

thanks beforehand,
Rikkart