Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy paste problem
Hi
I'm using the following code to try to paste over some formulas as value by all i get is "object does not support this property or method on the paste line, any thoughts? xlWB.sheets("Formulas").Cells.Select myExcel.Selection.Copy xlWB.sheets("Formulas").range("A1").Activate myExcel.sheets("Formulas").activecell.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False xlWB.CutCopyMode = False xlWb is the workbook object myExcel is the application object |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy paste problem
Give a try this:
With Worksheets("Formulas").Range("A1:IV5000") ..Value = .Value End With |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy paste problem
that did it, thanks a million
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy paste problem
On Monday, April 2, 2012 6:33:42 AM UTC-5, Keith Willis wrote:
that did it, thanks a million That may have taken awhile. Could have been faster with With Worksheets("Formulas").usedrange.specialcells(xlfo rmulas) ..Value = .Value End With |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy paste problem
Thanks Don.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy/Paste Problem | Excel Programming | |||
Copy and paste problem | Excel Discussion (Misc queries) | |||
Copy and Paste Problem | Excel Discussion (Misc queries) | |||
copy paste problem? | Excel Discussion (Misc queries) | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) |