Date with VBA
Hello,
I need to know if it is possible in a VBA macro to do the following:
In Worksheet # 1
I have the following text values in rows:
K1 30.11.2004
k2 24.12.2004
k3 30.10.2004
k4 25.11.2004
I would like to have a macro that would go through each line and determine the
oldest date and copy that date into Worksheet #2 with the format mn-yy. In
the example above: it'd be Oct-04
Thanks for any help,
JF
|