Allan,
You're not really copying cells when you use the formula in C1. You're using
the values contained in those cells to create a new value. The formats
reside with the cell, not the value.
This looks like a user-defined function with VBA problem. That's not my
area, but I'm sure that others on the list will
On my list of to this to do, I want to work through Chris Albright's VBA for
Modelers. It's primarily VBA for Excel users. If other assumers know
anything about it, I'd be interested in their thoughts.
Sorry, I can't come up with a solution.
CS
-----Original Message-----
From: R. Allan Reese [mailto:[log in to unmask]]
Sent: Tuesday, July 17, 2001 5:49 AM
To: [log in to unmask]
Subject: Copying text with style
This is such an obvious bug, I must be missing something.
If text is copied from one cell to another, it loses the formatting. Can
the formatting be retained?
eg
a1 = "italic text" and is italic (by cell format or as part of the text)
b1 = "bold text" and is bold
c1 = +a1&b1 and is plain text. All formatting lost.
|