Is it simply a lack of a space before the AND?
[vba]
rst.Filter = "COUNTERPARTYCODE >= " & Range("E4").Value & " AND " & _
"COUNTERPARTYCODE <=" & Range("E26").Value
[/vba]
Is it simply a lack of a space before the AND?
[vba]
rst.Filter = "COUNTERPARTYCODE >= " & Range("E4").Value & " AND " & _
"COUNTERPARTYCODE <=" & Range("E26").Value
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote