put the line in an auto_open macro in the ThisWorkbook module.

Range("g6") = Range("g6") + 1



--
Don Guillett
SalesAid Software

"slvtenn" wrote in message
oups.com...
How can i make an excel spread sheet, in a certain cell like G6, count
up one number from the number already entered in cell G6 everytime i
open that spread sheet? Any help would be greatly appreciated!!