Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PasteSpecial - is it possible to use values and format? 1

Status
Not open for further replies.
bluegnu

bluegnu

Technical User
Sep 12, 2001
131
GB
I was wondering if it is possible to do a pastespecial in excel using xlPasteValues and xlPasteFormats? I would like to be able to paste the values (not the formulas) but also keep the formatting within the cells.

Is this possible?

thanks
 
Sort by date Sort by votes
Call the PasteSpecial method 2 times.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Excellent, one of those simple solutions. Thanks!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mohamadmh
  • Locked
  • Question
Improve speed of For i Loop ? Is is possible to use arrays
Replies
9
Views
574
Andrzejek
Andrzejek
morechocolate
  • Locked
  • Question
run-tune error 3704 operation is not allowed when the object is codes: I don't think so.
Replies
7
Views
1K
morechocolate
morechocolate
Andrzejek
  • Locked
  • Question
Copy data between SQL and Oracle 1
Replies
8
Views
1K
remeng
remeng
remeng
  • Locked
  • Helpful tip
Microsoft Office 365 Word Macro Causing a Project is unviewable error
Replies
1
Views
1K
dhookom
dhookom
JAB_123
  • Locked
  • Question
I want to use an excel file for inp
Replies
3
Views
497
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top