Thank you Hank..........
The solution you offered works perfectly........exactly as I desired.
The only question I have now, is that since my "cell" is actually A63:G69
merged as a single cell, it in fact WILL display over the 256 characters I
thought was the limit..........what's up there?.........do I get 256 for
every cell in the merge?
Sorry, I'm not quite following you. I understood that 256 characters
was a limit that YOU wanted to impose for whatever reason. No cell,
whether individual or merged, has an Excel-imposed 256 character
limit. The actual limits are (from "Excel Specifications and Limits"
in the help file), "32,767 characters. Only 1,024 display in a cell;
all 32,767 display in the formula bar." (Disclaimer 1; I once saw a
post from Harlan which used the Rept function and other wizardry to
create an entry in a cell with more characters than that. While it was
an amusing circus trick and interesting as all get out from a "pushing
the envelope" point of view, I've yet to see a practical use for such
a cell entry. For most practical purposes, you may regard the limits
as stated in the help file as being "real". Disclaimer 2: Versions of
Excel PRIOR TO Excel 97 apparently DID have a 255 character limit for
the cells. This is mentioned in the "What's new with specifications
and performance" section of the Excel 97 Help file.)
A further limit stated in the help file is that a column width maxes
out at 255 characters BUT that doesn't take into account text wrapping
as set through the Format Cells dialog; it's just the actual column
width.
As far as the code in the Worksheet_Change procedure goes, it sees the
merged range Target variable as just a single cell. You can test this
by adding the line MsgBox Target.Address to the procedure; it will
return the address $A$63.
Hope this helps; if not, please post again with more details.