I am looking to find a macro or update the one that I have so that I can with a short cut key have it automatically set the row height so that all the wrapped text will be shown. I was given a macro by someone else that automatically set the row height each time the text wraps in a cell. Up until now it has worked great, but the size of my spread sheet and the number of tabs has grow to large and this macro is now takes 20 seconds every time you hit enter. So what I am trying to write or hoping someone else can help me with is a macro that will adjust the row height for any merged cells that I select and that I can assign to a shortcut key. I am working in windows 7 with excel 2007.
Thanks for any help or suggestions.
Thanks for any help or suggestions.