View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default How do I copy a cell with effects?

[a1].Copy [E1]

copied correctly i.e. A1 had superscript or subscript (7th with "th" as
either super/sub)

XL2003

"avsmith" wrote:

I am trying to copy a cell that has both regular text and subcripts
(effects). When I copy it, the new cell only shows regular sized text. I am
trying not to retype these cells because my program is rather lengthy and if
a title changes, I would like all of them to change in the subsequent pages.

I am using Excel 2003.

Thank you.