If you are doing this via VBA you don't need to use the pastespecial, you can
simply use code like this:

Range("P9:P17").Value = Range("N9:N17").Value

or if you are pasting the values over the original calculations then

With Range("N9:N17")
.value = .value
End With

Hope this helps
Rowan

"Curt" wrote:

I'm working on a macro and I need to Paste values only for a range. I can't
get the help file for macros for some reason. I guess I just need to know
the propper syntax for that function if anyone knows. I'm using Excel 2002.