when i do what you have done at 21:37 i get an error. Object doesnt suport the property or method. WH2 = "" If ShowActive = False Then If WH2 <> "" Then WH2 = WH2 & " AND " WH2 = WH2 & "Status <> ""Complete""" End If
Reply from Alex Hedley:
Which line is highlighted in the Debugger?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.