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.

Paste Special a string value
 

I think your options are to either format the "to" cell or use the copy
method to capture the "from" cell format.

"carl" wrote:

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.

Paste Special a string value
 

I thought as much.

Thanks anyway.

"JLGWhiz" wrote:

I think your options are to either format the "to" cell or use the copy
method to capture the "from" cell format.

"carl" wrote:

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.