PasteSpecial Sub Fails

[DougStroud]

Help w/ failing sub please... why is this failing?

With Wsf
.Range("J4:AA" & LRowf).Copy
.PasteSpecial Paste:=xlValues
End With

Thanks,

Doug

 

[jindon]

Because you are not specifying the range for paste
Is this what you wanted?

With Wsf.Range("J4:AA" & LRowf)
    .Copy
    .PasteSpecial Paste:=xlValues
End With

 

[DougStroud]

Hello Jindon,
Yes that is what I wanted.
I keep using/mis-understanding the proper syntax of placing the Worksheet reference on the different line than the range.

Thanks Jindon

 

[jindon]

OK
You can make reference to the object with "With" statement

Wsf.Range("J4:AA & LRowf).Copy
Wsf.Range("J4:AA & LRowf).PasteSpecial Paste:=xlValues

is equals to

With Wsf.Range("J4:AA & LRowf)
     .Copy
     .PasteSpecial Paste:=xlValues
End With

With Wsf.Range("J4:AA & LRowf)
     .Value = .Value
End With

 

[DougStroud]

Thanks Jindon-
Should have figured this one out, but nice to have you looking over my shoulder.....