Hello,
I'm trying to get a cell reference into my footer, specifically 'Pg 1!A5'. I want this to be in the middle column of my footers for each page, but I don't know how to get it in there and I heard you have to use macros. Can someone assist?
Hello,
I'm trying to get a cell reference into my footer, specifically 'Pg 1!A5'. I want this to be in the middle column of my footers for each page, but I don't know how to get it in there and I heard you have to use macros. Can someone assist?
Hi aegliveinterns
I'm a little confused as to your requirements but play with this code and see if it approximates what you wantPlace the code in the worksheet module, deactivate the worksheet, activate the worksheet then do a "Print Preview". If it's close, perhaps we can refine it.Please Login or Register to view this content.
Last edited by jaslake; 03-09-2011 at 08:51 PM.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Hi jaslake, I also needed to reference cells in a footer so I thank you for your help above. I placed the code in the worksheet module but now there is a little bit of "thinking time" when that worksheet is activated. Though minimal, is there a way to minimize this lag?
Hi burnst83
Not that I'm aware. You may wish to start a new Thread with this issue...perhaps another may know the answer.
Ok, thank you for your fast response!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks