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
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