Hidden Dan
Board Regular
- Joined
- Dec 7, 2016
- Messages
- 63
Hello,
I'm not so well in VBA programming but I understand howit works.
I have a spreadsheet consisting of 15 different sheets. They should be integrated in a complex document from different sources. The final pdf document is paginated but the XLS sheets should provide the correct page number. Currently I add the number manually in sheets footer.
I wonder if the page number could be read from a cell value. The advantage would be that I don't have to select each individual sheet footer and type in its page number.
Would there be a VBA script that can read from cell A1 a number and print this in the right section of the footer ?
Say,
Sheet A : pagenumber = 10
Sheet B : pagenumber = 12
Sheet C : pagenumber = 15
Thanks,
Dan
I'm not so well in VBA programming but I understand howit works.
I have a spreadsheet consisting of 15 different sheets. They should be integrated in a complex document from different sources. The final pdf document is paginated but the XLS sheets should provide the correct page number. Currently I add the number manually in sheets footer.
I wonder if the page number could be read from a cell value. The advantage would be that I don't have to select each individual sheet footer and type in its page number.
Would there be a VBA script that can read from cell A1 a number and print this in the right section of the footer ?
Say,
Sheet A : pagenumber = 10
Sheet B : pagenumber = 12
Sheet C : pagenumber = 15
Thanks,
Dan