if you are talking about mudraker's code

you said:
need some type of macro that if a cell in W is greater than "" a
cell in F, then F's value will automatically appear in W.

As written, W's value appears in F.

--
Regards,
Tom Ogilvy


"aapp81" wrote in message
...

thanks a lot - just what i was looking for!


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/