.Text .Formula .Value to replace copy_paste values?
 

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

.Text .Formula .Value to replace copy_paste values?
 

Did you read all the posts at your other thread?



Rikkart wrote:

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

--

Dave Peterson

.Text .Formula .Value to replace copy_paste values?
 

Hi Dave,
thanks for the reply. (I couldn't find my previous post, so couldn't check -
even now, searching for "copy_paste" doesn't give me this post in the
results. Pagebrowsing still works...)

Anyway, thanks, I tried NumberFormat but that didn't help, but I'll try
including Value2.
(Meanwhile, I actually tested the copy-paste option, and processed 1062
lines in 5 minutes instead of in 12 seconds (with errors))

any further clues?

"Dave Peterson" wrote:

Did you read all the posts at your other thread?



Rikkart wrote:

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

--

Dave Peterson
.

.Text .Formula .Value to replace copy_paste values?
 

I use google to search groups.

http://groups.google.com/advanced_se...blic.excel. *

Give it enough information (you as the author, maybe a keyword or date) and
you'll find it.

You could always force it to be Text:

with somecell
.numberformat = "@"
.value = someothercell.text
end with



Rikkart wrote:

Hi Dave,
thanks for the reply. (I couldn't find my previous post, so couldn't check -
even now, searching for "copy_paste" doesn't give me this post in the
results. Pagebrowsing still works...)

Anyway, thanks, I tried NumberFormat but that didn't help, but I'll try
including Value2.
(Meanwhile, I actually tested the copy-paste option, and processed 1062
lines in 5 minutes instead of in 12 seconds (with errors))

any further clues?

"Dave Peterson" wrote:

Did you read all the posts at your other thread?



Rikkart wrote:

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

--

Dave Peterson
.


--

Dave Peterson