Hi
with activesheet
if .range("H1").value<.range("G1").value then
msgbox .range("a1").value
elseif .range("H1").value.range("G1").value then
msgbox .range("c1").value
else 'equal
msgbox "not defined"
end if
end with

--
Regards
Frank Kabel
Frankfurt, Germany

sciacqua1 wrote:
How do I do a formula to select a certain cell. If GH I want the
program to select cell A. If HG than I want the program to select
cell C. How do I program this. What tool do I use.

thanks
Mike