Thanks Dave,
So how can I get the formatting to copy across aswell?

"Dave Peterson" wrote:

Formulas return values--not formats like this.



dim wrote:

Hi,
I'm using the old straightforward " = B5" to copy across text from B5 into
my new cell. No problems there, but I want whatever text formatting is in B5
to copy across aswell. Changing the format of my new cell is not an option
because it's locked for the user.
Any ideas?
Thanks....

--

Dave Peterson