Or = myRange.Value Insert Cell Content into Header or Footer in All Worksheets If you need to add a cell value into the RightHeader or RightFooter, and you just need to change one code line( or ) in above VBA Function as below line: = myRange.Value If you want to add a cell value into the footer in your current worksheet, and you can use the following VBA Macro.Ī = myRange.Value Step6: Select One Single Cell that you want to put its into Header or Footer. Step5: back to the current worksheet, click on Macrosbutton under Code group. Set myRange = Application.InputBox("Select One Single Cell that you want to put its into Header or Footer", "InsertCellValueIntoHeader", myRange.Address, Type:=8)Ī = myRange.Value Step4: paste the below VBA code into the code window. Step3: click “ Insert” ->” Module” to create a new module. Step2: then the “ Visual Basic Editor” window will appear. Step1: open your excel workbook and then click on “ Visual Basic” command under DEVELOPER Tab, or just press “ ALT+F11” shortcut. ![]() To put a cell value into the header or footer in your current worksheet in Excel, and you can do the following steps: ![]() ![]() ![]() Insert cell Content into Header or Footer in a Worksheet
0 Comments
Leave a Reply. |