In , Dana DeLouis
spake thusly:

Ah. cool beans. Thanks, Dana.

Now on to problem 2 ... :-)

=dman=

=======================================
Problem 1

Hi. Check the "AutoFilterMode" Property.
Here's one idea...

Sub Demo()
'// Near Beginning of Code
With ActiveSheet
'// Remove AutoFilter if On
If .AutoFilterMode Then .AutoFilterMode = False
End With

'// Now, start w/ your code
'// ...etc

End Sub