Is there a way to include a cell location in the custom footer?
Is there a way to include a cell location in the custom footer?
It looks like you need to use VBA code:
I find an example in a Mr Spreadsheet book that gives
I'd bet putting a ".address" behind the above code would do you.Please Login or Register to view this content.
Another example is at: http://support.microsoft.com/kb/213615
Last edited by MarvinP; 09-05-2010 at 10:35 AM.
Where do I put the above code?
You need to get to the VBA or Developer tab.
You can do this from the immediate window or create a subroutine to do it many times.
There are many tutorials on the net for doing this. Here is just one of many.
http://www.anthony-vba.kefra.com/vba/vbabasic1.htm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks