if you have code that sets it up, just rerun it. if you use the lastrow
variable, it should work fine

--


Gary


"CFD" wrote in message
...

Thanks! That works to turn it off, but it does not work to turn it back
on again (i.e. if I use
ActiveSheet.AutoFilterMode = False

... paste stuff ....

ActiveSheet.AutoFilterMode = True

it comes up with the error "Unable to set the AutofilterMode property
of the worksheet class" on the = true line ...?


--
CFD


------------------------------------------------------------------------
CFD's Profile:
http://www.excelforum.com/member.php...o&userid=27306
View this thread: http://www.excelforum.com/showthread...hreadid=476079