Just worked out how to do it by right-clicking on sheet tab and "View Code".

"TimS" wrote:

Hi, Have loaded this code into the VB area of Excel, but it doesn't run.
Expect that I am missing something, can you please advise how to load it.

Thanks.

"Hpyifur" wrote:

When I merge cells and then choose the wrap text option the Autofit function
no longer works. Is there a way to get around this without manually sizing
the row each time?