Can you post the code where it gets the userform data and the Autofilter is
invoked plus a few lines that you say are not getting processed.

Also is the userform closed before the Autofilter is invoked?

Have you tried putting a msgbox between some of the lines that you believe
are not being processed to establish whether in fact they are not being
processed?

--
Regards,

OssieMac


"KBarrett" wrote:

I have a spreadsheet that was created in an earlier version of Excel
and is now being used in Excel 2007 with compatibility mode on. One
of the macros filters the data on the sheet, using the autofilter
command, based on selections the user has made via a pop-up form.
Previous to Excel 2007, this was working fine. Now it appears the any
command lines following the autofilter command are ignored. Has
anyone encountered a similar situation?