µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excelµ{¦¡°Ï
» Äæ¦ì¿ï¨ú°ÝÃD
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
Äæ¦ì¿ï¨ú°ÝÃD
funnydisk
µoµu®ø®§
¥[¬°¦n¤Í
funnydisk
·í«eÂ÷½u
UID
9956
©«¤l
28
¥DÃD
13
ºëµØ
0
¿n¤À
68
ª÷¿ú
68
ÂI¦W
0
§@·~¨t²Î
winXP
³nÅ骩¥»
office2003
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
36 ¤p®É
µù¥U®É¶¡
2012-7-4
³Ì«áµn¿ý
2015-9-29
¤¤¾Ç¥Í
©«¤l
28
¥DÃD
13
ºëµØ
0
¿n¤À
68
ÂI¦W
0
§@·~¨t²Î
winXP
³nÅ骩¥»
office2003
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2012-7-4
³Ì«áµn¿ý
2015-9-29
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2012-8-10 18:08
|
¥u¬Ý¸Ó§@ªÌ
Äæ¦ì¿ï¨ú°ÝÃD
¦³¤GÓ«D³sÄòÄæ¦ì¿ï¨ú(A1,B1)¡A¦ý¸ê®ÆB1ªø«×¦h©óA1
¿ï¨ú®É¡A«o¥HA1¬°¥D¡An¦p¦ó¥H³Ìªø(B1)¬°¥D©O¡AÁÂÁÂ
A1 B1
2 6
3
1
7 3
5
Set a = Range(A1, Range("a65536").End(xlUp))
Set b = Range(B1, Range("a65536").End(xlUp))
Union(a, b).Select
¼Ó¥D¼ö©«
I´º°õ¦æ
¤À¨É¤@Ó¦Û¾ÇExcel VBAªººô¯¸
³sÄò°õ¦æ¥¨¶°
¸ê®Æ½Æ»s
¦p¦ó¯à¤£n¸õ°T®§
cellÄæ¦ì°ÝÃD
±Æ§Ç°ÝÃD
Äæ¦ì®æ¦¡
°}¦C°ÝÃD
¸ê®Æ¿ï¨ú°ÝÃD
¦¬ÂÃ
¤À¨É
Hsieh
µoµu®ø®§
¥[¬°¦n¤Í
Hsieh
·í«eÂ÷½u
UID
3
©«¤l
4901
¥DÃD
44
ºëµØ
24
¿n¤À
4916
ª÷¿ú
4916
ÂI¦W
239
§@·~¨t²Î
Windows 7
³nÅ骩¥»
Office 20xx
¾\ŪÅv
150
©Ê§O
¨k
¨Ó¦Û
¥x¥_
¦b½u®É¶¡
4097 ¤p®É
µù¥U®É¶¡
2010-4-30
³Ì«áµn¿ý
2024-11-4
¶W¯Åª©¥D
©«¤l
4901
¥DÃD
44
ºëµØ
24
¿n¤À
4916
ÂI¦W
239
§@·~¨t²Î
Windows 7
³nÅ骩¥»
Office 20xx
¾\ŪÅv
150
©Ê§O
¨k
¨Ó¦Û
¥x¥_
µù¥U®É¶¡
2010-4-30
³Ì«áµn¿ý
2024-11-4
2
#
µoªí©ó 2012-8-10 21:38
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
1#
funnydisk
Set a = Range("A1", Range("a65536").End(xlUp))
Set b = Range("B1", Range("b65536").End(xlUp))
Union(a, b).Select
¾Ç®üµL²P_¤£®¢¤U°Ý
TOP
funnydisk
µoµu®ø®§
¥[¬°¦n¤Í
funnydisk
·í«eÂ÷½u
UID
9956
©«¤l
28
¥DÃD
13
ºëµØ
0
¿n¤À
68
ª÷¿ú
68
ÂI¦W
0
§@·~¨t²Î
winXP
³nÅ骩¥»
office2003
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
36 ¤p®É
µù¥U®É¶¡
2012-7-4
³Ì«áµn¿ý
2015-9-29
¤¤¾Ç¥Í
©«¤l
28
¥DÃD
13
ºëµØ
0
¿n¤À
68
ÂI¦W
0
§@·~¨t²Î
winXP
³nÅ骩¥»
office2003
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2012-7-4
³Ì«áµn¿ý
2015-9-29
3
#
µoªí©ó 2012-8-11 00:32
|
¥u¬Ý¸Ó§@ªÌ
·PÁÂHsieh¤jªº¦^ÂСA¬O§Ú¤Ö¥´¤F""¡A¦pªG¬O³oÓ»yªk¡A¥u·|¿ï¨ú¨ìA1ªº7¨ºÓ¼Æ¦r¨º¦C¡A¤£·|¥]§tB1ªº5¡A©Ò¥H·Qn½Ð±Ð¦p¦óA1»PB1¦³¸ê®Æªº³£¯à¿ï¨ú¨ì¡AÁÂÁÂ
TOP
GBKEE
µoµu®ø®§
¥[¬°¦n¤Í
GBKEE
·í«eÂ÷½u
UID
16
©«¤l
5923
¥DÃD
13
ºëµØ
1
¿n¤À
5986
ª÷¿ú
5986
ÂI¦W
0
§@·~¨t²Î
win10
³nÅ骩¥»
Office 2010
¾\ŪÅv
150
©Ê§O
¨k
¨Ó¦Û
¥xÆW°ò¶©
¦b½u®É¶¡
4811 ¤p®É
µù¥U®É¶¡
2010-5-1
³Ì«áµn¿ý
2022-1-23
¶W¯Åª©¥D
©«¤l
5923
¥DÃD
13
ºëµØ
1
¿n¤À
5986
ÂI¦W
0
§@·~¨t²Î
win10
³nÅ骩¥»
Office 2010
¾\ŪÅv
150
©Ê§O
¨k
¨Ó¦Û
¥xÆW°ò¶©
µù¥U®É¶¡
2010-5-1
³Ì«áµn¿ý
2022-1-23
4
#
µoªí©ó 2012-8-11 05:43
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
3#
funnydisk
¬O³o¼Ë¶Ü?
Option Explicit
Sub Ex()
Dim R As Integer
R = IIf(Cells(Rows.Count, 1).End(xlUp).Row > Cells(Rows.Count, 2).End(xlUp).Row, Cells(Rows.Count, 1).End(xlUp).Row, Cells(Rows.Count, 2).End(xlUp).Row)
Range("a1:b" & R).Select
End Sub
½Æ»s¥N½X
TOP
funnydisk
µoµu®ø®§
¥[¬°¦n¤Í
funnydisk
·í«eÂ÷½u
UID
9956
©«¤l
28
¥DÃD
13
ºëµØ
0
¿n¤À
68
ª÷¿ú
68
ÂI¦W
0
§@·~¨t²Î
winXP
³nÅ骩¥»
office2003
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
36 ¤p®É
µù¥U®É¶¡
2012-7-4
³Ì«áµn¿ý
2015-9-29
¤¤¾Ç¥Í
©«¤l
28
¥DÃD
13
ºëµØ
0
¿n¤À
68
ÂI¦W
0
§@·~¨t²Î
winXP
³nÅ骩¥»
office2003
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2012-7-4
³Ì«áµn¿ý
2015-9-29
5
#
µoªí©ó 2012-8-11 10:58
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
4#
GBKEE
·PÁÂGBKEE¤j¡A³o¼Ë¥i¥H¹B¦æ¤F¡AÁÂÁÂ
TOP
ÀR«ä¦Û¦b :
«H¤ß¡B¼Ý¤O¡B«i®ð¤TªÌ¨ã³Æ¡A«h¤Ñ¤U¨S¦³°µ¤£¦¨ªº¨Æ¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·