| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to do that
hello, suppose there are 100 cells, A1.......A100, they have the values 1.....100 how can I programming it when I open the worksheet, the cells already contain those numbers?Thank you. -- lwong ------------------------------------------------------------------------ lwong's Profile: http://www.excelforum.com/member.php...o&userid=33707 View this thread: http://www.excelforum.com/showthread...hreadid=535213 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to do that
Dim i As Integer
For i = 1 To 100 Sheets(1).Range("A" & i) = i Next -- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "lwong" wrote: | | hello, suppose there are 100 cells, A1.......A100, they have the values | 1.....100 | how can I programming it when I open the worksheet, the cells already | contain those numbers?Thank you. | | | -- | lwong | ------------------------------------------------------------------------ | lwong's Profile: http://www.excelforum.com/member.php...o&userid=33707 | View this thread: http://www.excelforum.com/showthread...hreadid=535213 | |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to do that
Open a blank worksheet and enter the desired numbers. Then save the
workbook. Then close the workbook. Whenever you re-open the workbook, the numbers will already be there! -- Gary's Student "lwong" wrote: hello, suppose there are 100 cells, A1.......A100, they have the values 1.....100 how can I programming it when I open the worksheet, the cells already contain those numbers?Thank you. -- lwong ------------------------------------------------------------------------ lwong's Profile: http://www.excelforum.com/member.php...o&userid=33707 View this thread: http://www.excelforum.com/showthread...hreadid=535213 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to do that
good suggestion of Gray's student, but dont forget here is programming area. Thank you, Dave Patrick -- lwong ------------------------------------------------------------------------ lwong's Profile: http://www.excelforum.com/member.php...o&userid=33707 View this thread: http://www.excelforum.com/showthread...hreadid=535213 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
![lwong[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
