copy value only...Copy Destination:=Cells(3, 2)

[Fan924]

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

 

[marcus]

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

 

[Dave Peterson]

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).value = .value
end with
end with

 

[Fan924]

Thanks Marcus & Dave