I would like to format my footer using VBA. I have my code listed below but I get a "Compile Error: Invalid Qualifier" and it highlights the Ftr in the first line of the With statement "With Ftr.Font". My code is below. How do I fix this?
Private Sub Worksheet_SelectionChange(ByVal Target As...