ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Counting!! (https://www.excelbanter.com/excel-discussion-misc-queries/72950-excel-counting.html)

slvtenn

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

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




slvtenn

Excel Counting!!
 
Thanks for the help Don it worked great!!


Don Guillett

Excel Counting!!
 
Easy if you know how.

--
Don Guillett
SalesAid Software

"slvtenn" wrote in message
oups.com...
Thanks for the help Don it worked great!!





All times are GMT +1. The time now is 02:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com