copy value only...Copy Destination:=Cells(3, 2)
Can this formula be modified to copy the value only?
Range(Cells(500 - SizeX, 3), Cells(500, 3)).Copy Destination:=Cells(3, 2) I am attempting go avoid using this code... Selection.Copy Range("B3").Select ActiveSheet.Paste Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False Thanks |
copy value only...Copy Destination:=Cells(3, 2)
Hi
To do what you want to do you need to split it over 2 lines. Certainly more efficiten than your second example. take care Marcus Range(Cells(500 - sizex, 3), Cells(500, 3)).Copy Cells(3, 2).PasteSpecial xlPasteValues |
copy value only...Copy Destination:=Cells(3, 2)
Another way is to just assign the values:
With activesheet 'I like qualifying my ranges! with .Range(.Cells(500 - SizeX, 3), .Cells(500, 3)) .Cells(3,2).resize(.rows.count,.columns.count).val ue = .value end with end with Fan924 wrote: Can this formula be modified to copy the value only? Range(Cells(500 - SizeX, 3), Cells(500, 3)).Copy Destination:=Cells(3, 2) I am attempting go avoid using this code... Selection.Copy Range("B3").Select ActiveSheet.Paste Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False Thanks -- Dave Peterson |
copy value only...Copy Destination:=Cells(3, 2)
Thanks Marcus & Dave
|
All times are GMT +1. The time now is 11:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com