Excel Macro Stopped Working

FuzzyTom

New Member
Joined
May 26, 2011
Messages
24
Excel 2007

My excel macro suddenly stopped working on a Windows 8.1 professional.

The macro starts and then just continues to run until I stop it.

Even if I "run to cursor" in visual basic the macro seems to be doing nothing and will run until I stop it.

This macro has been working for close to a year now on the Windows 8.1 laptop.

To test the macro, I then made a copy and installed it on my Vista and it runs without any problems.

Any ideas as to what the problem might be or any suggestions on how to troubleshoot this issue on the Windows 8.1 laptop?

Thanks.
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
FuzzyTom,

In order to assist you it would help us if you posted all of your macro code using code tags.

When posting VBA code, please use Code Tags - like this:

[code=rich]

'Paste your code here.

[/code]
 
Upvote 0
Thanks for your help, but it turns out that there was a blank field in the data that somehow hung the VBA this time.

Usually it just give me a message but this time it just put the program into a loop.

I have it running just fine now.

Is it possible to remove the question since it was a user error rather than a problem with VBA coding.
 
Upvote 0
FuzzyTom,

You are welcome.

Glad that you were able to solve your own request.

And, come back anytime.
 
Upvote 0

Forum statistics

Threads
1,213,538
Messages
6,114,218
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top