Searching for values in a given range and then prepending a formula
Hello
I'd trying to write some code to do the following. Any help much
appreciated.
Find the last row in the worksheet with cells that are not empty, then
define a selection between that row and row 4.
Within that selection, iteratively find cells that contain a value
(number only). For each cell that does, take that number and write
into a simple formula in that cell: '=[found value]/$H$3'.
Thanks
Ben
|