Re: Copy and PasteSpecial help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

try

with range("c15:bk15")
..value=.formula
end with
--
Don Guillett
SalesAid Software
dguillett1@xxxxxxxxxxxxx
"chemicals" <chemicals@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0AF46404-A1C4-4CD4-96F4-BB80133D4B2A@xxxxxxxxxxxxxxxx

I have simple code:

Sheets("DW").Range("C15:BK15").Copy
Sheets("DW").Range("C11").PasteSpecial(xlValues)

I get the follwoing error:

Error 1004
Unable to get the PasteSpecial property of the Range class

What gives?


.

Quantcast