Help! Inserting numbers in excel cells

[mollymabel]

I am typing up tickets for a raffle and there are already over a
thousand cells. I now want to insert numbers to them so that when they
print, each ticket has a number- 1 thru 1,500.
Anyone know how to do this?
Thanks! Molly

 

[Jim]

Are you using Excel? Are you printing 1 ticket per sheet? You can stick this
in the
Workbook_BeforePrint event:
Range("A1").Value = Range("A1") + 1

 

[Rich Wallach]

Molly,
You can use Excel's fill feature as follows:
1) Select a blank column for your series
2) Start the series in the first 3 rows (e.g. 1,2,3)
3) Select the entire ranges where you want the series
including your seed values (1,2,3)
4) Selet Edit | Fill | Series from the menu
5) Select the stop value, for you 1500
6) Click OK

Hope that helps and good luck with your raffle.
Rich

 

[Dan E]

Molly,

I'm not sure if this is exactly what you want, but if all you
need is a column with numbers 1 to 1500

Put 1 in say F1
Put 2 in F2
Select both cells, grab the little square in the bottom right
of the selected cells (your cursor should turn into a cross)
drag down and it will increment the numbers
ie F3 = 3
F4 = 4
etc...

Dan E