Menu

Macro Problem

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.programming

Dave Peterson Dave Peterson is offline

Dave Peterson is offline

external usenet poster

Posts: 35,218

Default

Macro Problem

Close all other running programs?????

wrote:

The problem I'm having occurs when I try and copy-paste special-values
a pivot table in a macro, do you have any suggestions to get around
this?

Sheets("Trading_Profit").Activate
Sheets("Trading_Profit")).Copy
Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False

--

Dave Peterson

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
MACRO Problem	Dan	Excel Discussion (Misc queries)	1	February 5th 10 11:07 PM
Macro problem	The Message	Excel Discussion (Misc queries)	2	December 8th 09 10:13 AM
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable	Enda80	Excel Worksheet Functions	1	May 3rd 08 02:35 PM
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable	Enda80	Excel Discussion (Misc queries)	1	May 3rd 08 10:52 AM
Problem in updating all worksheets of a workbook using a macro that calls another macro	[email protected]	Excel Programming	3	March 20th 06 05:21 AM

All times are GMT +1. The time now is 04:20 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement