I have a worksheet designed to print a certain kind of document. In this case
it is gross composition for a product. There are several different products
which fit into this template I have designed. The amount of information in
this document varies, which gives me a problem with the bottom of the
document. I want a prdoct specific text at a fixed point at the bottom. The
footer option will do that, but it will not allow me to place cell
information in it. Using VB will only put in the correct text when I open the
document. What I would like to do is having the footer change "realtime" when
the cell, that it refers to, changes.

Anyone know if this is possible?

What about an event macro?

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(False, False) = "A10" Then _
ActiveSheet.PageSetup.LeftFooter = Target
End Sub

Change A10 to your fixed cell!

Regards,
Stefi


€žsoinx€� ezt Ã*rta:

I have a worksheet designed to print a certain kind of document. In this case
it is gross composition for a product. There are several different products
which fit into this template I have designed. The amount of information in
this document varies, which gives me a problem with the bottom of the
document. I want a prdoct specific text at a fixed point at the bottom. The
footer option will do that, but it will not allow me to place cell
information in it. Using VB will only put in the correct text when I open the
document. What I would like to do is having the footer change "realtime" when
the cell, that it refers to, changes.

Anyone know if this is possible?