For some odd reason my code is acting like there are breakpoints in a handful
of locations. I tried exporting the module, deleting the old excel file,
creating a new excel file, importing the module, and running it. Same thing
happened. Then I copied the code into Word, deleted the Excel file,
re-created it, and pasted the code into a new module. Same problem.

Any ideas???

I'm using Excel 2007.

I'd try:

Inside the VBE with your workbook's project selected:

Tools|Options|General tab
change the error trapping from "break on all errors" to "break in class module"



Mike wrote:

For some odd reason my code is acting like there are breakpoints in a handful
of locations. I tried exporting the module, deleting the old excel file,
creating a new excel file, importing the module, and running it. Same thing
happened. Then I copied the code into Word, deleted the Excel file,
re-created it, and pasted the code into a new module. Same problem.

Any ideas???

I'm using Excel 2007.

--

Dave Peterson