[VBA]szSQL = "SELECT * FROM [" & SourceSheet$ & "$" & SourceRange$ & "] WHERE [KEY5] = 10;"[/VBA]

this works but when I try this it fails

[VBA]szSQL = "SELECT * FROM [" & SourceSheet$ & "$" & SourceRange$ & "] WHERE [Team_Leader] = XAZ80;"[/VBA]

Is this because this is a text and numeric field if so how can i get it to work?