PasteSpecial Sub Fails

DougStroud

Well-known Member
Joined
Aug 16, 2005
Messages
2,968
Help w/ failing sub please... why is this failing?

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

Thanks,

Doug
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

jindon

MrExcel MVP
Joined
Aug 21, 2004
Messages
16,995
Because you are not specifying the range for paste
Is this what you wanted?
Code:
With Wsf.Range("J4:AA" & LRowf)
    .Copy
    .PasteSpecial Paste:=xlValues
End With
 

DougStroud

Well-known Member
Joined
Aug 16, 2005
Messages
2,968
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

MrExcel MVP
Joined
Aug 21, 2004
Messages
16,995
OK
You can make reference to the object with "With" statement
Code:
Wsf.Range("J4:AA & LRowf).Copy
Wsf.Range("J4:AA & LRowf).PasteSpecial Paste:=xlValues
is equals to
Code:
With Wsf.Range("J4:AA & LRowf)
     .Copy
     .PasteSpecial Paste:=xlValues
End With
Code:
With Wsf.Range("J4:AA & LRowf)
     .Value = .Value
End With
 

DougStroud

Well-known Member
Joined
Aug 16, 2005
Messages
2,968
Thanks Jindon-
Should have figured this one out, but nice to have you looking over my shoulder.....
 

Forum statistics

Threads
1,181,102
Messages
5,928,062
Members
436,586
Latest member
latintxn

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top