On Wednesday, May 25, 2016 at 6:08:08 PM UTC-4, Claus Busch wrote:
Hi Michael,

Am Wed, 25 May 2016 14:28:08 -0700 (PDT) schrieb michaelberrier:

Ok, my error. The macro runs if their is an entered value in the reference cell. I'm trying to use a formula in that cell. Is that possible?

if you have a formula in A1 you have to use Worksheet_Calculate event:
Private Sub Worksheet_Calculate()
ActiveSheet.Name = "Total " & Range("A1").Value
End Sub


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

MONEY! Thank you sir.