Macro just stops without any error message

**Kyle1978** · 04-24-2012, 05:39 PM

Ok, this is my first post and I have to admit that I'm not very good at VBA but I can usually mess with things enough until I figure them out but this is one that I'm not having any luck with. A co-worker of mine actually created this macro and it runs fine. The only part that I added is the next to the last line - Sheets("building").Select

But, when I add this line, it doesn't seem to run - the rest of the code runs but that part does not and, there is no error message - it just seems to treat that line like it is not even there. When I run just that line by itselft, it works fine. It just won't work as part of the larger macro. Any ideas what could be causing this?

Thanks!

Please Login or Register  to view this content.

**Richard Buttrey** · 04-24-2012, 05:50 PM

Hi

Is the 'building' sheet hidden?

**Kyle1978** · 04-24-2012, 06:00 PM

No, it's not hidden.

**Richard Buttrey** · 04-24-2012, 08:47 PM

When you say it doesn't seem to run what do you see assuming you run the macro when 'building' isn't the active sheet? What do you expect to see.

Are any columns or rows hidden? If so it's possible that the last cell selected is in the hidden row or column.

Please upload your workbook so that we can see the problem in context.

**Kyle1978** · 04-25-2012, 09:35 AM

The macro is generally supposed to run from the "B.S.T." worksheet. When it's run, it should clear any of the selections that have been made on that worksheet which, it does, but that's where it stops when what I want it to do is simply select the "Building" worksheet. I actually want it to run another macro, once it's on that worksheet but I've removed that from the current code to try to simplify the problem b/c, the sticking point seems to be that it won't do anything after "Sheets("keyword").select". There are hidden rows and columns on this worksheet but the last cell that is selected is always "Keyword" which, is not hidden. I've uploaded the workbook.

**Richard Buttrey** · 04-25-2012, 02:24 PM

Hi,

Your range 'keyword' is blank. Hence in your procedure 'MySearch' when your variable 'MyFind' = "" is encountered (after it's been set to the keyword value), the 'Then End' instruction is ending any more macro processing.

Regards