Thread: Copy Across Formatting aswell using "=[Cell Ref]" ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dim dim is offline
external usenet poster
  
Posts: 123
Default Copy Across Formatting aswell using "=[Cell Ref]" ?
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....
Reply With QuoteReply With Quote