yes, rng should be dimmed as Range

--
Regards,
Tom Ogilvy

"agarwaldvk " wrote in message
...
Tom

Thanks a lot for your quick response. Greatly appreciated.

I take it that "rng" is to be dimmed as Range.

I didn't know a range name could be converted to a range simply by
doing so :-

Range(range name)

Great! Thanks again! I have learnt something today!


Best regards


Deepak Agarwal


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