Try this:
' At the top of the sub
Dim Var As String
Var = "BEST"
'
'
'
"WHERE (`ORDER PROJECTIONS`.LB4= " & Var & ")"
"vehement" wrote in message
...
::bump:: any help would be appreciated
--
vehement
------------------------------------------------------------------------
vehement's Profile:
http://www.excelforum.com/member.php...o&userid=15417
View this thread: http://www.excelforum.com/showthread...hreadid=270221