View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Carl Carl is offline
external usenet poster
 
Posts: 361
Default Paste Special a string value

I have the following piece of code:

ActiveCell.Offset(1, 0).Value = strA

Is there anyway of populating the cell with the value of StrA as a
pastespecial values? Because StrA has a different format (font and size)
than where it is being posted to.