Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
extract hidden date
I have date in range a1 to a2000
On only one line there will be a date. Is there a simplecommand that can find this date. At present i am using the following code. Set CHECKRANGE = Columns(1).Cells For Each CELL In CHECKRANGE If CELL.Text Like "*##/##/20##*" Then ........ ......... NEXT CELL an example of the date in column is " 146.01 153.80 n/a 0.06 -1.85 ( -1.3%) n/a 03/03/2006 0 £0.00 £0.00 n/a " i need to find and extract that date. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extract date from last cell | Excel Discussion (Misc queries) | |||
extract date from text | Excel Worksheet Functions | |||
Extract Date | Excel Worksheet Functions | |||
extract date from the most current date | Excel Discussion (Misc queries) | |||
Extract date from cell | Excel Worksheet Functions |