Crash on running macro

[george.krompacky]

Hi. I'm using Excel 2004 on a iMac G5 with the latest OS and updates
etc etc. My Microsoft preferences have been trashed and I've repaired
permissions.

I rarely use Excel and only in the most basic way. But today I'm
creating some charts and cleaning up some data and it occured to me
that a macro would speed things up. So I created a very simple macro
to remove the character "m" from some numbers. Excel consistently gets
the spinning beach ball after running the macro.

I tried creating another simple macro--just as an experiment--in
another workbook and it, too, instantly freezes up Excel.

So I'm thinking that perhaps something about running macros in itself
is causing a problem, and not anything with any particular macro. Any
ideas?

 

[JE McGimpsey]

So I'm thinking that perhaps something about running macros in itself
is causing a problem, and not anything with any particular macro. Any
ideas?

It's hard to tell without seeing your macros. XL is not inherently prone
to crashing while running macros, though there are certainly some
instability issues for certain methods.

Do you have any add-ins loaded? Did you trash your preferences with all
Office applications closed?

What OS and XL versions are you using?

 

[george.krompacky]

It's hard to tell without seeing your macros. XL is not inherently prone
to crashing while running macros, though there are certainly some
instability issues for certain methods.

Do you have any add-ins loaded? Did you trash your preferences with all
Office applications closed?

What OS and XL versions are you using?

Thanks for the reply. Don't have any Excel-related add-ins loaded.
Yes, preferences were trashed with no MS apps running.

Excel 11.3.6
Mac OS X 10.4.10

Here is the macro--it's so simple that I can't believe it's the
problem:

Sub remove_extra()
'
' remove_extra Macro
' Macro recorded 8/22/2007 by George Krompacky
'
' Keyboard Shortcut: Option+Cmd+k
'
Selection.Replace What:="M", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
Selection.Replace What:="$", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
End Sub

 

[JE McGimpsey]

Excel 11.3.6
Mac OS X 10.4.10

Here is the macro--it's so simple that I can't believe it's the
problem:

I agree. It works fine for me.

FWIW, XL's latest version is 10.3.7, but I also don't think that's the
problem.

Does the crash happen with a fresh workbook?

What do you have selected when you try to run the macros?

 

[george.krompacky]

FWIW, XL's latest version is 10.3.7, but I also don't think that's the
problem.

Does the crash happen with a fresh workbook?

What do you have selected when you try to run the macros?

That's odd, selecting "About Excel" or examining in the Finder both
show 11.3.6 for me LOL.

I'm starting to think that this problem is tied into overall weird
Excel behavior re: saving a newish document. I can't pin down the
actual behavior, but often when I start an Excel document, I'll type
in a couple of cells and then think I'd better do a save. It's at that
point that Excel crashes.

Like I said, I don't need to use XL that much, and I've gotten to the
point where I sort of trick it into starting a new document without
crashing, by saving first, or saving after one or two keystrokes only.
I find if I can just get the document saved, and then it crashes, I
can delete preferences, open the saved document and then not have any
problem. It's just starting a new document that is plagued with
crashes.

So, perhaps a reinstall of Office is in order. I'm on top of all the
usual OS X maintainance fixes--fonts are okay etc--and no other
application is misbehaving but XL.

 

[JE McGimpsey]

So, perhaps a reinstall of Office is in order. I'm on top of all the
usual OS X maintainance fixes--fonts are okay etc--and no other
application is misbehaving but XL.

Probably worth a shot, but I'd guess that by itself it will have zero
effect, simply because applications almost never corrupt, while
preferences often do. If you do reinstall, make sure you run the Remove
Office application to uninstall, rather than simply trashing the
application folder.

If you have a Personal Macro Workbook, or any other file in your startup
folder (by default it's

HD:Applications:Microsoft Office 2004:Office:Startup:Excel

though you can set an alternate in Preferences/General), I'd try
trashing/moving that file first.

 

[george.krompacky]

Probably worth a shot, but I'd guess that by itself it will have zero
effect, simply because applications almost never corrupt, while
preferences often do. If you do reinstall, make sure you run the Remove
Office application to uninstall, rather than simply trashing the
application folder.

If you have a Personal Macro Workbook, or any other file in your startup
folder (by default it's

HD:Applications:Microsoft Office 2004:Office:Startup:Excel

though you can set an alternate in Preferences/General), I'd try
trashing/moving that file first.

Yes, in all honesty I don't think it will do anything either LOL.

I don't have any start-up Office items. However, while browsing those
folders I realize that there are some add-ins. This is my office
computer and I'm assuming these are all add-ins from the default
Office installation but I suppose i could be wrong. Please let me know
if anything here is should be trashed...

In /Applications/Microsoft Office 2004/Office there is
ExcelPrintPDE.plugin

In /Applications/Microsoft Office 2004/Office/Add-Ins there are
Conditional Sum Wizard
Eurotool.xla
HTML.XLA
Lookup Wizard
Report Manager
Set Language
Solver.xla

and in /Applications/Microsoft Office 2004/Office/Add-Ins/Analysis
Tools there is
Analysis ToolPak
Analysis Toolpak - VBA
FuncRes
ProcDBRes

 

[JE McGimpsey]

This is my office computer and I'm assuming these are all add-ins
from the default Office installation

They are.