"Flawlesgem" wrote:
The solution is perfect to what i am looking for

Welcome. Pl take a moment to rate that earlier response. Go back and click
the Yes button (like the one below). Thanks.

One more thing what if the formula in the cell not refer to any range, only
just refer to two individual cells like =A1*A4

I suppose you mean a discontiguous range?
Still possible to define such, eg:
MyR: =Sheet1!$A$1,Sheet1!$A$4
but it may not work as expected, unlike the earlier contiguous range
You could try tinkering around with it

Ditto for a single cell defined range, eg:
MySingleR: =Sheet1!$A$1

If you mean operate likewise w/o using a defined range, I don't know.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---