I have added the below code to show the project Code from the Worksheet in the Footer and it start taking long time to open the work sheet.
Is anyone know the efficent way to use the data from the sheet in the Footer.
Dim projectCodeFooter
projectCodeFooter = Worksheets("status").Range("C7").value
Worksheets("status").PageSetup.LeftFooter = "project ID:" & projectCodeFooter
Is anyone know the efficent way to use the data from the sheet in the Footer.
Dim projectCodeFooter
projectCodeFooter = Worksheets("status").Range("C7").value
Worksheets("status").PageSetup.LeftFooter = "project ID:" & projectCodeFooter