VBA Paste Plain Text

I'm using Excel 2000.

I have a worksheet full of formulas that I can manually copy and paste into a new sheet, but when I try to do it using a macro, it fails.

My lines look like this:

shtTemp.Range("A1").PasteSpecial xlPasteAll

Which works fine, except that most of my source data are formulae. When I try to paste like this:

PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

I crash.

Is there a way in VBA to paste special? All I want is plain text, no formatting or wrapping...