thanks frank! man, i knew it had to be possible, but i couldn't find i
anywhere! i really appreciate all the help you give to this board,
know personally your tips and help have helped me be able to create
great excel project!

Frank Kabel wrote:
*Hi
change the line
If Range("F20") <= Range("C2") <= Range("F23") Then

to
If Range("F20").value <= Range("C2").value and _
Range("C2").value <= Range("F23").value Then


--
Regards
Frank Kabel
Frankfurt, Germany


--
Message posted from http://www.ExcelForum.com