Thanks for the help. I'm actually using an old Macro and just trying to
modify it for my purposes. It wasn't written using vba, it's typed out in an
excel spreadsheet. But there's a function in excel itself called
Paste.Special(...) that I can't get help for. I'd need to use this function
for this type of macro or start from scratch. Can anyone tell me how that
function works? Thanks.

Curt

"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.