VBA code for MID MIN Find combination formula

[redmarko]

I require the VBA equivalent of the formula below. I have figured some of it out like the double quotes and the relative cell locations.

[CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE]  

Thanks in advance

[shg]

In consultation with my crystal ball, maybe

Row\Col	A	B	C
10	123418.0	18.0	B10: =RM(A10)
11	1217.0x	17.0
12	1234	18.0

Please Login or Register  to view this content.