Hi,

Am Mon, 16 Feb 2015 12:00:31 +0100 schrieb Claus Busch:

aa = "EMEA"
bb = "South Africa"
daformula = "=AND($g1=""" & aa & """,$e1=""" & bb & """)"

or try it this way:

aa = """EMEA"""
bb = """South Africa"""
daformula = "=AND($g1=" & aa & ",$e1=" & bb & ")"


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional