Nima
New Member
hi to all,
i have a big data sheet and when i want to print it it break in several page. i want show total of some columns in each sheet when i am printing.
i Know i could insert a content of a cell into footer like below:
.....
With ActiveSheet
.PageSetup.CenterFooter = .Range("A1").Text
....
but exactly i want to no use of any cell to insert content in footer.
is there any solution to insert a formula like sum() in footer to act individually?
i have a big data sheet and when i want to print it it break in several page. i want show total of some columns in each sheet when i am printing.
i Know i could insert a content of a cell into footer like below:
.....
With ActiveSheet
.PageSetup.CenterFooter = .Range("A1").Text
....
but exactly i want to no use of any cell to insert content in footer.
is there any solution to insert a formula like sum() in footer to act individually?