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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

copy without formulas

Status
Not open for further replies.
OneMixedUpStranger

OneMixedUpStranger

Technical User
Joined
Dec 4, 2001
Messages
7
Location
IS
Hello

Can I copy all the contents out of one Excel workbook into another without the formulas? So the second workbook has no formulas in it just what it says in the windows. I hope you uderstand this.

Thank you in advance
 
Sort by date Sort by votes
the PasteSpecial method might be what you are looking for
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question Question
Copy data between SQL and Oracle
Replies
8
Views
2K
remeng
remeng
remeng
  • Locked
  • Question Question
Delete dynamic table rows without removing password protection
Replies
7
Views
870
remeng
remeng
JTBorton
  • Locked
  • Question Question
Determine when a userform is closes without the Terminate event
Replies
6
Views
1K
JTBorton
JTBorton
MattGreer
  • Locked
  • Question Question
Excel - Copy Filtered Rows from a table to a new blank worksheet
Replies
7
Views
794
combo
combo
Katto
  • Locked
  • Question Question
VBA create link to a module without running it
Replies
5
Views
515
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top