Claus Busch wrote:

Hi Terry,

Am Wed, 19 Aug 2015 17:26:03 +0100 schrieb Terry Pinnell:

For many years I've used my own macro program, Macro Express Pro, for
automating stuff. Haven't touched VBA for a decade or so. Therefore
working out exactly how to paste that VBA macro will need a bit of
revision!

press Alt+F11 = Insert = Module and paste the code into the code
window. Then select the cell and run the macro.

What has to be revised? Do you have more than one cell with long text in
one column? I have a suggestion for that case.


Regards
Claus B.

Thanks very much, Claus. That works a treat. And your multiple line
version too.

Never seen an XLSM file before - very handy. This page, the first I
found with a google search, seemed to imply my ancient version of
Excel wouldn't work, but it did:
http://pcsupport.about.com/od/fileex...f/xlsmfile.htm appeared

What has to be revised? Well, just about everything!

My 80 or so macros were created over 20 years ago, and I haven't
really worked with macros for at least 15 years. I see my 'Excel 3
User Guide' was published in 1990.

I did initially check whether I already had a suitable macro and found
one named 'Wrap' as you see he
https://dl.dropboxusercontent.com/u/...ldMacros-1.jpg
But that simply applies Format Cells Alignment Wrap cell.

After following your instructions, I was unsure how to proceed beyond
this stage:
https://dl.dropboxusercontent.com/u/...l-Macros-2.jpg

Anyway, one way or another, it worked and solved the immediate task.
I'll avoid the strong temptation to interrupt my current project (I'm
making a family DVD) to re-study Excel macros. But as a result of your
help I will at least be able to successfully copy/paste if necessary
for the time being!

--
Terry, East Grinstead, UK