To apply any formatting to the footer other than the default you will need to add special formatting codes, and you can also use special data codes that Excel recognizes for headers and footers. If you want the contents to be in a different part of the footer, you can change LeftFooter to CenterFooter, or RightFooter. The macro is run every time Excel does its normal recalculation-meaning every time the contents of any cell changes or someone presses F9. Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)Ī = Range("A1").Text The following is an example of a macro that will place the contents of cell A1 into the left side of the footer: The easiest way to do this is with a macro. You may find it helpful to sometime place the contents of a cell into the footer of a worksheet, and to have the footer updated every time the contents of the cell changed.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |