Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 6th 08, 07:01 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2008
Posts: 4
Default generate different number

hi,
is there a way that excel would generate a different number ( incremented by
one) each time a workbook is opened?
thanks
paul



  #2   Report Post  
Old October 6th 08, 07:46 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2008
Posts: 364
Default generate different number

Yes but only by using VBA...The following will increment the value in cell L1
on Sheet1 by one every time the workbook is open.

Private Sub Workbook_Open()
Sheets("Sheet1").Range("L1").Select
ActiveCell.Value = ActiveCell.Value + 1

End Sub

"Paul" wrote:

hi,
is there a way that excel would generate a different number ( incremented by
one) each time a workbook is opened?
thanks
paul



  #3   Report Post  
Old October 6th 08, 08:39 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 11,501
Default generate different number

Paul,

Have a look here

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Mike

"Paul" wrote:

hi,
is there a way that excel would generate a different number ( incremented by
one) each time a workbook is opened?
thanks
paul





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
Serial number generate Tony Excel Worksheet Functions 4 October 20th 07 04:59 AM
generate a random number and use if function to generate new data Dogdoc1142 Excel Worksheet Functions 4 April 26th 06 03:44 AM
Generate number NOT using a form DavisC New Users to Excel 2 March 4th 05 01:21 AM
how can text be set up to generate a number? jwmaes New Users to Excel 3 January 25th 05 01:32 PM
generate serial number john douglass Excel Worksheet Functions 0 November 5th 04 10:49 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017