Excel Counting!!

[slvtenn]

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!!

[Don Guillett]

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

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



--
Don Guillett
SalesAid Software
[email protected]
"slvtenn" <[email protected]> wrote in message
news:[email protected]...
> 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!!
>

[slvtenn]

Thanks for the help Don it worked great!!

[Don Guillett]

Easy if you know how.

--
Don Guillett
SalesAid Software
[email protected]
"slvtenn" <[email protected]> wrote in message
news:[email protected]...
> Thanks for the help Don it worked great!!
>