6/26/2023 0 Comments Vba insert current date in excelIf 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. |