#1   Report Post  
Posted to microsoft.public.excel.misc
slvtenn
 
Posts: n/a
Default 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!!

  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett
 
Posts: n/a
Default 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!!



  #3   Report Post  
Posted to microsoft.public.excel.misc
slvtenn
 
Posts: n/a
Default Excel Counting!!

Thanks for the help Don it worked great!!

  #4   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett
 
Posts: n/a
Default 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!!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
unhide menu bar in excel - just disappeared Sean Setting up and Configuration of Excel 12 April 4th 23 10:19 AM
convert pocket excel back to standard excel kevroyal Excel Discussion (Misc queries) 1 February 16th 06 11:35 AM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
conditional counting with Excel LeicaElmar Excel Worksheet Functions 1 October 17th 05 10:23 PM
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 08:07 PM


All times are GMT +1. The time now is 07:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"