Avatar of chris pike
chris pike
Flag for Canada

asked on 

Excel VB - format error

I am getting an error on this line in my VBA

 For Each rngSupervisor In Range("tblSupervisor[Supervisor]")
        sBody = "Here is the expiration report as of " & Format(Now, "yyyy/mm/dd") & " for " & rngSupervisor & "   -  Please Recertify ASAP " & vbNewLine

Open in new window


the error that highlights is the "FORMAT"
Any idea why?  Thanks so much
Chris
Microsoft Excel

Avatar of undefined
Last Comment
chris pike

8/22/2022 - Mon