- Oct 31, 2008
I have the code posted below and when it runs, it flags with and Invalid Qualifier error. I don't know why it is doing so. It highlights the title of the macro in yellow, and has the Ftr in the With statement also highlighted selected. Any ideas would be great.
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) Dim Ftr As String ActiveSheet.PageSetup.RightFooter = "Machine: " & Sheets("Safety").Range("M1").Value Ftr = ActiveSheet.PageSetup.RightFooter.Text With Ftr.Font .Name = "Calibri" .FontStyle = "Bold" .Size = 18 End With End Sub