It seems to work if you add this line to the code...
Application.Volatile

Ctrl + Alt + F9 also works.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"tplourde"
wrote in message
Why doesn't this function refresh. The only time it refreshes is when I
activate the cell, press F2 and Enter.

Function SheetIndex(rngSheet As Range) As Long
SheetIndex = rngSheet.Parent.Index
End Function