Re: $$Excel-Macros$$ Transpose (Arr) problem with Dates

2012-08-30 Thread dguillett1
August 30, 2012 12:57 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Transpose (Arr) problem with Dates First post guys! I am trying to convert dates stored as text into proper formatted UK dates DD/MM/. A sample spreadsheet is attached. The dates as text are copied into a

$$Excel-Macros$$ Transpose (Arr) problem with Dates

2012-08-30 Thread RLM
First post guys! I am trying to convert dates stored as text into proper formatted UK dates DD/MM/. A sample spreadsheet is attached. The dates as text are copied into a variant array, converted to a real date using DateSerial then copied to a new range using the WorksheetFunction.Transp