software

I've used Jim Rech's autofit macro for merged cells. It works great. Thanks!

Seems I have to use alt-f8 to run the macro and make the merged cells
autofit everytime I make a change (add text). Is there a way to make it work
automatically, perhaps so that the macro is quot;always runningquot;?

What you want is to run the macro on a worksheet change event. To do that,
make sure the macro code is in the worksheet (Right-click the sheet and hit
View Code and paste it into the code window there, if it's not already).
Then, rename the macro so that it's called Private Sub
Worksheet_Change(ByVal Target As Range)
(or you can create a NEW macro with this name and call the other macro from
it.
I am not sure this will work perfectly for you, but will definitely give you
a place to start.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;Cindy Bquot; gt; wrote in message
...
gt; I've used Jim Rech's autofit macro for merged cells. It works great.
gt; Thanks!
gt;
gt; Seems I have to use alt-f8 to run the macro and make the merged cells
gt; autofit everytime I make a change (add text). Is there a way to make it
gt; work
gt; automatically, perhaps so that the macro is quot;always runningquot;?