@ JosephP,

Thanks for pointing it and me too read that in Microsoft site whether anyother method which gets the reference without filename and including the sheet reference or we have to use Instr() function and split and assign the reference in a variable and refer it in formula?