Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel 2000
- Thread starter jbeone
- Start date
JVFriederick
IS-IT--Management
Please give a little more info.
Copy FROM where TO where, exactly?
Copy FROM where TO where, exactly?
If you want to use the contents of a cell as footer, say the contents of A1 as left footer, then
ActiveSheet.PageSetup.LeftFooter = Range("A1"
.Value
in a macro will do that for you. The footer will update to reflect changes in the cell's value.
IS
ActiveSheet.PageSetup.LeftFooter = Range("A1"
.Valuein a macro will do that for you. The footer will update to reflect changes in the cell's value.
IS
JVFriederick
IS-IT--Management
Ilses, I think you nailed it.
We'll find out.
We'll find out.
- Status
