I have 3 columns of data and am doing a number of things on it. Most o
the stuff I figured out from the recorder and just taking formulas an
integrating those into a macro.
The problem is copying a numeric value from the cells to another cell.
Some of the cells contain the text "mil" and are preceeded by a number.
I was wondering how it would be coded in the macro to search through th
cells for the text "mil" then take the value before it and copy it t
another cell.
I know how to place the value once you have it into another cell.
just don't know how to get the value.

Help/Links are helpful. I tried searching but don't know if I wa
using correct search text.

TI

--
w0cyru0
-----------------------------------------------------------------------
w0cyru01's Profile: http://www.excelforum.com/member.php...fo&userid=2581
View this thread: http://www.excelforum.com/showthread.php?threadid=39215