Thanks David,
I run the macro but it shows only the filename as C:\My Documents\NEWS.xls
but does not show Sheet Name (Sheet1, Sheet2 etc.) The range I mean is not
cell value. I have given the range A1:E5 as salary, G1:I10 as Grades etc. Now
I want the range names Salary and Grades in the footer.

I also want to convert actual fig.(A1=457899356.5664, A2=7979464889.455669
etc) in Lakhs or crores or thousands at one go as well as separately. How can
I do this? Will Excel prompt me before converting actual figures into Lakhs
/ Crores / Thousands ? Does this require a macro?

Please help.

"David McRitchie" wrote:

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