try

with range("c15:bk15")
..value=.formula
end with
--
Don Guillett
SalesAid Software

"chemicals" wrote in message
...

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?