Subroutine is halted, but Excel acting strange - Cells don't appear selected...

What to know:
-Excel 2010
-Windows 7
-Sheet is not protected
-Restarting the program seems to fix it, until it eventually happens again.
-Workbook attached. Button labeled: Click Here to Add Resource at row 50

I run a macro that finds a 3 word string on a sheet, copies its row and the one below it, then inserts the copied cells over itself.
Most of the time it works. But when it doesn't, I get the infamous:

Run-Time Error: 1004
Application-defined or object-defined error

The obvious first assumption is that my .Find did not find what it was looking for. However, knowing that string is there (and this macro runs successfully most of the time), I'm not sure why I get this error.

However, the real problem is after I END the macro. I can no longer see an outline around the cells I select, nor will the contents of the cell appear in the formula bar at the top. I can double click in a cell, and I can see my cursor and edit the contents, but I cannot see the selected cell.

Two noticeable things:
-The mouse is indicated by a hollow plus sign (same one you see when you hover over a highlighted area)
-The mouse still turns into a hand when hovering over buttons.


Here's the code:

Please Login or Register  to view this content.

I do have error handling, but I didn't include it to save space. When it works, it works great. When it errors, it never works again, and the sheet acts as mentioned previously.

Any clues? What obvious thing am I missing...

Hello paulcola,

There may be many reasons why this code is failing. To get an answer to this problem more quickly, you should post a copy of your workbook.

To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.

File Manger Picture

Hello paulcola,

Perhaps now you'll consider my earlier request in Post #2.

Hello paulcola,

Perhaps now you'll consider my earlier request in Post #2.

Problem still exists, regardless of the .Activate statement.

I'm thinking

Please Login or Register  to view this content.

is the culprit. Wonder if there's a better way to do this...

Hello paulcola,

Thanks for posting the workbook. It opened as a 95-2003 format. Is this being used on OS versions earlier than 2007 only?

Hello paulcola,

I was curious if this program was being or going to be run on more than one computer. Usually a workbook that will be used by more than one user will be saved in an earlier version for backward compatibility.

Do you need the workbook saved in this earlier format?

Thank you AlphaFrog. That's a lot of time you spent there, I appreciate that. I was just able to make it happen again - unfortunately, it's quite random. I'll let it sit a while, run the macro, and it happens. Next time, it doesn't.

That's an excellent point Leith. I won't know until Monday. I don't want to save it as an earlier version, and would rather not. I need to find that out.

The last time I got it to fail, Excel actually crashed. I'm now wondering if you're on to something Leith. There might be compatibility issues going on here. The code I've posted is not enough to make excel croak so easily.

EDIT: In answer to your question, yes, many other computers (not shared, but saved on other PCs quite a bit)

Good advice. I will!

Wait, just errored. newResourceRow is 93, which was the correct row at the time.

When it's in that mode (where I can't seem to select cells), and I step into the code, I notice the last line it reads before it errors out is

Please Login or Register  to view this content.

That may not be saying much though. I think the spreadsheet is just stuck in some weird "I've selected something" mode, and it won't allow copying, pasting, etc. Or, as Leith is intimating, there's a possible compatibility issue going on.

Jeez! I may have to setup some arrays or something to track every variable at every moment to see where it goes wrong.

Maybe one of you can test this:

I've been able to duplicate the issue three times by zooming way out of the spreadsheet, then clicking a button.
Using the zoom bar at the bottom right, I zoomed out to 30%, then clicked on CLICK HERE TO ADD RESOURCE under Telephony.

UPDATE: I can duplicate it every time with zooming!
UPDATE 2: I am able to pinpoint where it fails. Right after zooming out, then executing this line:

Please Login or Register  to view this content.

The variables are correct, nothing is null or zero. But it doesn't like that line after zooming out for some reason. : S