Raja;413100 Wrote:
Thanks advice please advice in which cell i hav eto copy paste the
formula
--- Automerged consecutive post before response ---


Thanks peocflyer

please advice where i have insert this formula as im new to excel.
--- Automerged consecutive post before response ---



Thanks for you reply,

i have inserted this code in the sheet1 view code but when checked its
not working please advice where i have apply this script.

Regards,

Raja

Pertaining to the formula you can insert it in any cell you need the
result to be


--
Pecoflyer

Cheers -

'Firefox 3.5' (http://www.mozilla.com/en-US/firefox/all-beta.html)
really IS fast !
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115078