Posted to microsoft.public.excel.programming

Steph[_3_] Steph[_3_] is offline

external usenet poster

Posts: 312

Paste as values

Hello. Below is a snippet from some code I have. How do I modify
this to paste values, so the formula doesn't carry through. Thanks!!

wkbk.Sheets("Opex & CAPEX").Copy After:=ThisWorkbook.Worksheets(1)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
find values in multiple cells and paste row values	izzyt1972	Excel Discussion (Misc queries)	5	December 26th 07 10:14 PM
can you change the default paste method? (paste values)	David A Brown	Excel Discussion (Misc queries)	3	December 18th 07 09:59 AM
Paste Values	ceemo	Excel Discussion (Misc queries)	2	May 10th 06 01:42 PM
Paste values ID	GregR	Excel Discussion (Misc queries)	1	December 13th 04 07:08 PM
Paste Values	STEVEB	Excel Programming	2	October 31st 03 05:14 PM

All times are GMT +1. The time now is 06:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us