A cell formula can get, but only a macro can set. Some exceptions (manually): Scenarios,
Goal Seek, Subtotals, Text to Columns and Advanced Filter, none of which is applicable to
your situation.

Signature
Regards from Virginia Beach,
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
> how to set(not get) a cell value to another cell?
> is it possible?