'VB CODEprivate sub splitDate()
Dim i, j, strSize, year, month, day as long
i = 1
j = 0
do while ActiveWorkSheet.Cells(i, 1)""
set dateNum = Trim(Mid(ActiveWorkSheet.Cells(i, 1), (strSize-6), strSize))
year = Val(Mid(dateNum, 0, 2))
month = Val(Mid(dateNum, 2, 2)) ...
|