Posted to microsoft.public.excel.programming

Gary Keramidas[_4_] Gary Keramidas[_4_] is offline

external usenet poster

Posts: 226

copy question

when you use the .copy method, is there any way to only copy formulas? or
do you have to use the paste method to achieve this?

this copies formats, too

Worksheets("Sheet1").Range("A1:D4").Copy _
destination:=Worksheets("Sheet2").Range("E5")

--

Gary

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
Another 'Copy To The Next Available Row' Question	Joe	Excel Discussion (Misc queries)	2	March 29th 10 04:25 AM
copy down question	[email protected]	Excel Worksheet Functions	6	January 28th 09 12:56 AM
Copy/Paste Question	DoubleZ	Excel Discussion (Misc queries)	3	September 24th 08 11:13 PM
Copy Formula Question	phowe43	Excel Discussion (Misc queries)	2	February 5th 08 07:28 PM
copy-move question	nastech	Excel Discussion (Misc queries)	1	January 31st 06 03:16 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us