Click here to reveal answer The =SQRT (25) is a square root For a cube root, use =125^ (1/3) For a fourth root, use =625^ (1/4) #2 The code you posted can be run manually and does update the header and footer in each worksheet You might want to change "Company Name" to "Company Name " & the variable that contains the companyThe sheet name should now be highlighted and editable Press Alt F8, select CreateTOC 1 through 4, press Run The alternative is to transpose the sheet, then name_columns_by_row and then save Get Sheet Name by Code Name If None, will default to Excel's default nameClick the worksheet where you want to add or change headers or footers On the Insert tab, in the Text group, click Header & Footer Excel displays the worksheet in Page Layout view
Where Is Header Footer In Microsoft Excel 07 10 13 16 19 And 365
