Ornithopter
New Member
- Joined
- Jul 5, 2004
- Messages
- 32
I'm wondering if there is any way to insert a Range of cells into the
footer. The effect I'm looking for is the same as if you were to go
to 'Page Setup'>Sheet>'Rows to Repeat at Top' except I want
'Rows to Repeat at Bottom'.
I have tried the following with no luck:
Where the range "B237:M239" contains the information
and formatting that I would like at the bottom of every
page.
Any ideas?
footer. The effect I'm looking for is the same as if you were to go
to 'Page Setup'>Sheet>'Rows to Repeat at Top' except I want
'Rows to Repeat at Bottom'.
I have tried the following with no luck:
Code:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
With ActiveSheet.PageSetup
.LeftFooter = Range("B237:M239").Text
End With
End Sub
Where the range "B237:M239" contains the information
and formatting that I would like at the bottom of every
page.
Any ideas?