Sort hyperlinks by time
xl2003, win xp
I have a column of hyperlinks that show the time but not the web address. In
addition to the time some cells show things like "4:21 F4" or "11:30 AM".
Others are just "4:00"
And this mucks up the sort order, with the cells with "F4" geting sorted
first. What I need is to filter out the "F4" so that the cells are sorted
by time only.
I have tried :- Range("J1:J57").Sort Key1:=Range("J1"),
Order1:=xlDescending, XlSortDataOption:=xlSortTextAsNumbers but it will not
compile.
Any help would be greatly appreciated.
Ta,
Martin
|