Thread: Disabling and re-enabling the AutoFilter from VBA
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
CFD[_8_] CFD[_8_] is offline
external usenet poster
  
Posts: 1
Default Disabling and re-enabling the AutoFilter from VBA

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

Reply With QuoteReply With Quote