Range name & Full Path in Footer

[Guest]

How can I put Range name & Full path of a file in footer?

 

[Ron de Bruin]

Hi Ajit

See
http://www.j-walk.com/ss/excel/tips/tip22.htm

 

[JE McGimpsey]

Check out

http://www.mcgimpsey.com/macoffice/excel/fullnameinfooter.html

 

[David McRitchie]

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.

 

[Guest]

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.

 

[Guest]

Thanks Ron
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]

Please stick to the question that was asked. Including another
unrelated question (lakhs) is confusing enough, but adding it after saying
you don't have the answer to the original question (the one that
matches the subject) is not helping you with any of your questions.

For the first question, I certainly have macros on the my page
that shows the pathname, filename, and sheetname, look again.
If you can't find it then show us exactly the format that you want
that information in and which footer.

Same for the range, please show the format you want the range
to show up as. You can use concatenation to show values.

For some help with Lakhs see my strings.htm and formula.htm pages.