VBA Error

I have a VERY large Excel 365 workbook running on a Windows 10 platform with many sheets. I want to have the left footer on each page of the printout to be contents of the cell "T1" on the page that it's printing. T1 is a vlookup formula that references another sheet. I have entered the text below as the VBA code in the ThisWorkbook object. When I have a VERY small workbook, this macro works as expected but on this large workbook, it gives me an error and highlights the macro row "WS.PageSetup.LeftFooter = WS.Range("T1").Value" in yellow. I noticed that when I highlighted the yellow macro text, it appears to give me text as if it's reading from an array in the T1 formula from a different table in the workbook.

Might ANYONE have an answer for me please. I'm totally confused.

Please Login or Register  to view this content.

Any help would be greatly appreciated.
RR

Please

• Show the formula that is in T1
• Give the error number and description (which you should always do when asking about a VBA runtime error)

If T1 is an array formula it could be producing results that can't be used in a page footer.

Share the formula, ideally in a workbook. If it's producing an array, you could use TEXTJOIN to concatenate the results.

Sample workbook = more help.

pls try activating each sheet before setting the footer.
Excel can handle each operation separately and avoid potential errors.
If it still doesn't work, please provide the T1 formula

Please Login or Register  to view this content.