Paste Special a string value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
I think your options are to either format the "to" cell or use the copy
method to capture the "from" cell format.
 
I thought as much.

Thanks anyway.

JLGWhiz said:
I think your options are to either format the "to" cell or use the copy
method to capture the "from" cell format.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replacing a value in the string variable 7
Time conversion 4
String to VBA Code Part 2 - Access 2003 3
Need Macro to run on all Worksheets at same time 2
Using Regex to Physicaly Highlight Non-match with Font Color 3
Paste Special Values 3
Paste values from 2 fields to an Excel sheet 4
Getting Properties and property values of a sealed class 3

Back
Top