Copy Range Values

[maxscott]

Hi

I have a little routine that copies values from a range (kfromrange) to another range (ktorange) as follows:

kRows = kfromrange.Rows.Count
kCols = kfromrange.Columns.Count
Set kzrange = ktorange.Resize(kRows, kCols)
kzrange.Value = kfromrange.Value

Problem is if excel recognises a cell's value as a potential date it changes it to a date. So a bank sort code of say 07-10-20 is changed to 44022 which with a format of dd/mm/yy is 10/07/20.

How can I stop excel doing this and just paste the values. I can use copy and paste values but using range value method above is so much quicker.

Thanks

[sweep]

Hi,

You could set the destination range formatting to text before writing the cells?

Please Login or Register  to view this content.