D
David Welch
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
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