Hi,

I need some help writing a macro that does the following:
-finds cells that are automatically populated by another cell (i.e. that contain "=A3" or "=B7"... any "=cell")
-look to the original cell and copy the contents
-paste the contents in the destination (populated) cell

I need to do this because I have cells with italicized text in them that don't carry the italics over to populated cells. This is (what I hope will be) the simplest work-around I could come up with. I just don't have the VBA knowledge to write this code. Any help or ideas would be greatly appreciated. Thank you!