I have 3 columns of data and am doing a number of things on it. Most of the stuff I figured out from the recorder and just taking formulas and 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 the cells for the text "mil" then take the value before it and copy it to another cell.
I know how to place the value once you have it into another cell. I just don't know how to get the value.
Help/Links are helpful. I tried searching but don't know if I was using correct search text.
TIA
Bookmarks