Hi,
I realize this is probably incredibly simple but I've somehow lost my
ability to do a paste special command in VB that was previously working.
Excel returns an error
"PasteSpecial method of range class failed". It happens from a module level
routine or worksheet level. As a side note, I've found at different times in
the past that my environment occassionally doesn't recognize other common
Excel constants and to get the ball rolling, I sometimes have to use a
literal in place of the constant name. I have Excel 2003 w/ Service Pack 2.

Worksheets("Sheet1").Range("aw7:ba7").Copy
Worksheets("Sheet1").Range("aw7:ba7").PasteSpecial xlPasteValues

Thanks much,