View Single Post
 
Old 12-03-2011, 12:45 PM
mike_abc mike_abc is offline Windows XP Office 2003
Novice
 
Join Date: Dec 2011
Posts: 9
mike_abc is on a distinguished road
Question Use formula to copy cell formats also

Hi,

Is there a way to copy the formats of individual cells when you concatenate them with the string concatenation operator (&) ? So far, I was only able to get the cell contents, but not the formatting.

Thanks,

Mike
Reply With Quote