Hi John,
I did the same kind of thing before seeing your reply, except that i passed the $workbook,$sheet_index as a argument to another function where i found out the sheet name using the same logic..
but your approach is the simplest and apt one i was looking for...
guess i've a knack to complicate simple things.. :)

Thanks a lot for educating me..

Regards,
joe