Hi Ajit,
You also asked how to put a range name into the footer, and for that
you definitely need a macro. Though I'm not sure what you mean by
putting a range name in the footer -- will assume you mean the value
of a cell.

For the full pathname in the footer my own page is
. http://www.mvps.org/dmcritchie/excel/pathname.htm

you might add code for the value of a cell as follows
ActiveSheet.PageSetup.RightFooter = Range("A1").text
or for the value of a defined name as follows:
ActiveSheet.PageSetup.RightFooter = Range("mycell").text
for something with a format
ActiveSheet.PageSetup.RightFooter = Format(now(),"dd-mmm-yyyy")

.text is used instead of .value, since .text will include your cell formatting

You will have to run your macro before printing.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Ajit Munj" wrote in message ...
How can I put Range name & Full path of a file in footer?
--
Knowldege is Power