Application.Transpose and Range of dates/data
 

Hi,

I have a range of dates and data which looks like so

01/01/2001 08/01/2001 ...
0.002% 0.0003% ...


Unfortunatly they go across and I want them to go down, so i take the
range and transpose it like so:

Value = Application.Transpose(Range.Value)

but now when i reference the dates they are in american format and typed
as strings!

This does not happen if I use Range.Value directly. If I do

Value = Application.Transpose(Range.Value2)

it works, but I would like to use only the dates formatted as dates on
the sheet, and not recognise any old number as a date.

I have tried recreated the problem in a seperate module, referencing the
same data, but I do not have the problem there!

If anyone has come across this problem then any help would be appreciated!

Thanks

---
Dave