¦p¦ó¥ÎVBA±N¦³¼Æ¦r»P¤å¦rªºÄæ¦ì¨º¤@¾ã¦C§R°£
- ©«¤l
- 79
- ¥DÃD
- 26
- ºëµØ
- 0
- ¿n¤À
- 111
- ÂI¦W
- 0
- §@·~¨t²Î
- winxp
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2011-12-20
- ³Ì«áµn¿ý
- 2022-8-3
|
¦p¦ó¥ÎVBA±N¦³¼Æ¦r»P¤å¦rªºÄæ¦ì¨º¤@¾ã¦C§R°£
½Ð°Ý¦p¦ó¥ÎVBA±NAÄæ¦ì¥un¦³¼Æ¦r»P¤å¦r¨Ò¦p21253AÄæ¦ì¨º¤@¾ã¦C§R°£
ÁÂÁÂ |
|
|
|
|
|
|
- ©«¤l
- 552
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 578
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-2-8
- ³Ì«áµn¿ý
- 2024-7-9
|
¦n¹³¦³¤å¦rªº¼Æ¦r³£µø¬°¤å¦r¡I |
|
|
|
|
|
|
- ©«¤l
- 79
- ¥DÃD
- 26
- ºëµØ
- 0
- ¿n¤À
- 111
- ÂI¦W
- 0
- §@·~¨t²Î
- winxp
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2011-12-20
- ³Ì«áµn¿ý
- 2022-8-3
|
¦^´_ 2# lpk187
¹ï³á!ÁÂÁ±zªº´£¿ô
¤£¹LÁÙ¬O¤£ª¾¹D¦p¦ó¥ÎVBA¤è¦¡¥h§R°£¾ãÓAÄæ¦ì¥X²{¤å¦rªº¨º¤@¦C |
|
|
|
|
|
|
- ©«¤l
- 79
- ¥DÃD
- 26
- ºëµØ
- 0
- ¿n¤À
- 111
- ÂI¦W
- 0
- §@·~¨t²Î
- winxp
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2011-12-20
- ³Ì«áµn¿ý
- 2022-8-3
|
¦^´_ 4# GBKEE
ÁÂÁ¤j¤j±Ð§Ú¤èªk §Ú¿ý»sªº¥¨¶°¬°:
Sub ¥¨¶°1()
'
' ¥¨¶°1 ¥¨¶°
'
'
Columns("A:A").Select
Selection.SpecialCells(xlCellTypeConstants, 2).Select 'AÄæ¦ì¥un¦³¤å¦r´N§R°£¾ã¦C
ActiveWindow.ScrollRow = 3
ActiveWindow.ScrollRow = 134
ActiveWindow.ScrollRow = 129
ActiveWindow.ScrollRow = 124
ActiveWindow.ScrollRow = 119
ActiveWindow.ScrollRow = 117
ActiveWindow.ScrollRow = 112
ActiveWindow.ScrollRow = 108
ActiveWindow.ScrollRow = 103
ActiveWindow.ScrollRow = 99
ActiveWindow.ScrollRow = 96
ActiveWindow.ScrollRow = 89
ActiveWindow.ScrollRow = 85
ActiveWindow.ScrollRow = 80
ActiveWindow.ScrollRow = 73
ActiveWindow.ScrollRow = 68
ActiveWindow.ScrollRow = 62
ActiveWindow.ScrollRow = 57
ActiveWindow.ScrollRow = 53
ActiveWindow.ScrollRow = 49
ActiveWindow.ScrollRow = 44
ActiveWindow.ScrollRow = 39
ActiveWindow.ScrollRow = 34
ActiveWindow.ScrollRow = 32
ActiveWindow.ScrollRow = 30
ActiveWindow.ScrollRow = 29
ActiveWindow.ScrollRow = 26
ActiveWindow.ScrollRow = 24
ActiveWindow.ScrollRow = 22
ActiveWindow.ScrollRow = 21
ActiveWindow.ScrollRow = 19
ActiveWindow.ScrollRow = 17
ActiveWindow.ScrollRow = 16
ActiveWindow.ScrollRow = 14
ActiveWindow.ScrollRow = 12
ActiveWindow.ScrollRow = 11
ActiveWindow.ScrollRow = 9
ActiveWindow.ScrollRow = 8
ActiveWindow.ScrollRow = 6
ActiveWindow.ScrollRow = 4
ActiveWindow.ScrollRow = 3
ActiveWindow.ScrollRow = 1
End Sub
¥i¬O¤£ª¾¹D¦p¦ó§R°£¿ï¥X¨Óªº¾ã¦C
ÁٽФj¤j«ü¾É¤@¤U
ÁÂÁÂ |
|
|
|
|
|
|
- ©«¤l
- 79
- ¥DÃD
- 26
- ºëµØ
- 0
- ¿n¤À
- 111
- ÂI¦W
- 0
- §@·~¨t²Î
- winxp
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2011-12-20
- ³Ì«áµn¿ý
- 2022-8-3
|
¦^´_ 6# GBKEE
ÁÂÁ¤j¤j±Ð¾Ç ¤]¸Ñ¨M§Úªº°ÝÃD |
|
|
|
|
|
|