| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question on autonumber
I’m sure this have been asked a thousand times, but I just need starting hand. I have built a quote sheet and now I want to have th quote number automatically update with the next available number. I a thinking I can put a TXT file in the same dir and then call it fro excel but I don’t know where to write. I want to call it Onopen. I am thinking it should look like this. ( I’m a novice with code.) Breneck Quote Sheet 2.Main.Range (“C17”).Value = NextSeqNumbe (“Quote.txt”) Am I on the right track -- Xeno ----------------------------------------------------------------------- Xenos's Profile: http://www.excelforum.com/member.php...fo&userid=2652 View this thread: http://www.excelforum.com/showthread.php?threadid=47197 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup and autonumber | Excel Worksheet Functions | |||
| Autonumber in a cell | Excel Discussion (Misc queries) | |||
| Autonumber from Form | New Users to Excel | |||
| autonumber | Excel Discussion (Misc queries) | |||
| autonumber values | Excel Worksheet Functions | |||
Threaded Mode
