Is it NG wrap-around?

Try

ActiveSheet.PageSetup.RightHeader = "Total: " & _
Application.SUM(Range("DollarVal"))


--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
ups.com...
Bob- Thanks for such a quick response. I still get an error:
Run-time error '1004':
Method 'Range' of object '_Global' failed

Am I missing something?