²é¿´: 2602  |  »Ø¸´: 10

veritascoco

гæ (³õÈëÎÄ̳)

[ÇóÖú] ExcelÇó½Ì£ºÓÐЧÊý¾ÝÌáÈ¡ ÒÑÓÐ1È˲ÎÓë

ExcelÇó½Ì£ºÔÚexcel±í¸ñÖÐÑ¡ÔñÒ»¶¨ÇøÓò½øÐÐÓÐЧÊý¾ÝÌáÈ¡£»
ÀýÈç5¡Á5±í¸ñÖУ¬ÔÚ×ø±ê£¨1£¬3£©£¬£¨2£¬2£©£¬£¨2£¬4£©£¨3£¬2£©£¬£¨4£¬3£©£¬£¨5£¬3£©£¨5£¬4£©ÓÐÓÐЧÊý¾Ý£¬ÈçºÎÌáÈ¡£¿·ÅÔÚͬһÐлòͬһÁУ¿
¹òÇó

ExcelÇó½Ì£ºÓÐЧÊý¾ÝÌáÈ¡
4KM6GI8`LYMV8M4YV3MKXKW.png
»Ø¸´´ËÂ¥

» ²ÂÄãϲ»¶

ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
»ØÌûÖö¥ ( ¹²ÓÐ1¸ö )

bcsnow

Ìú¸Ëľ³æ (ÖøÃûдÊÖ)

veritascoco: »ØÌûÖö¥ 2017-12-12 18:50:04
ÒýÓûØÌû:
8Â¥: Originally posted by veritascoco at 2017-12-12 13:41:51
ÄúºÃ£¬»¹ÏëÇë½ÌÕâ¸ö¿ÉÒÔÓñàдһ¸öС³ÌÐòʵÏÖÂ𣿿ÉÒÔÇó½ÌÒ»ÏÂÂð£¿ÒòÊý¾ÝÁ¿´ó£¬Óиö³ÌÐò¿ÉÄܸü·½±ã¡£
vbºÃ¾ÃûÓö¼Íü¼ÇÁË£¬·Ç³£¸Ðл...

Õ⻹ÄÜÍü£¿°ÑÄã±í¸ñ·¢¸øÎÒÊÔÊÔ¿´
9Â¥2017-12-12 16:48:26
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
»ØÌûÖ§³Ö ( ÏÔʾ֧³Ö¶È×î¸ßµÄǰ 50 Ãû )

bcsnow

Ìú¸Ëľ³æ (ÖøÃûдÊÖ)

ÒýÓûØÌû:
5Â¥: Originally posted by veritascoco at 2017-12-01 16:15:26
ÕÒµ½ÁË£¬µ«²»ÊǺܶ®±à³Ì£¬Õâ¸öÐèÒª±à³ÌÂ𣿿ÉÒÔÖ¸µ¼Ò»ÏÂÂ𣿷dz£¸Ðл...

Sub test()'¼òµ¥Ð´Ò»Ï£¬²âÊÔͨ¹ý
k = 6
For j = 1 To 5 'ºó°´ÁÐËÑË÷
For i = 1 To 5 'ÏȰ´ÐÐËÑË÷
If (Cells(i, j) <> 0) Then
Cells(k, 1) = Cells(i, j) 'µÚÒ»ÁеÚkÐпªÊ¼±£´æ
k = k + 1
End If
Next
Next
End Sub
6Â¥2017-12-01 17:22:24
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
ÆÕͨ»ØÌû

bcsnow

Ìú¸Ëľ³æ (ÖøÃûдÊÖ)

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

¸Ðл²ÎÓ룬ӦÖúÖ¸Êý +1
ÓÃvba£¬°´ÐÐÁбéÀú£¬ÌáÈ¡ÓÐЧÊý×Ö£¬´æµ½Í¬Ò»ÐÐ/ÁÐÖÐ
2Â¥2017-12-01 09:34:38
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

veritascoco

гæ (³õÈëÎÄ̳)

ÒýÓûØÌû:
2Â¥: Originally posted by bcsnow at 2017-12-01 09:34:38
ÓÃvba£¬°´ÐÐÁбéÀú£¬ÌáÈ¡ÓÐЧÊý×Ö£¬´æµ½Í¬Ò»ÐÐ/ÁÐÖÐ

vba£¬ÐèÒªÎÒµ¥¶ÀÏÂÔØÂ𣿻¹ÊÇÔÚexcelÀï¾Í¿ÉÒÔʵÏÖ°¡£¿¿ÉÒÔ½ÌÒ»ÏÂÂ𣬷dz£¸Ðл²»ÊǺܶ®
3Â¥2017-12-01 11:42:04
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

bcsnow

Ìú¸Ëľ³æ (ÖøÃûдÊÖ)

ÒýÓûØÌû:
3Â¥: Originally posted by veritascoco at 2017-12-01 11:42:04
vba£¬ÐèÒªÎÒµ¥¶ÀÏÂÔØÂ𣿻¹ÊÇÔÚexcelÀï¾Í¿ÉÒÔʵÏÖ°¡£¿¿ÉÒÔ½ÌÒ»ÏÂÂ𣬷dz£¸Ðл²»ÊǺܶ®...

¿´Äãexcel²Ëµ¥ÉÏÃæÓпª·¢¹¤¾ßÒ»Ïî²»£¬Ã»ÓÐÓÒ¼üÔÚ×Ô¶¨Ò幦ÄÜÇøÀïµ÷³öÀ´£¬µã×ó±ßµÄvisual basic ¾Í¿ÉÒÔÁË
4Â¥2017-12-01 15:16:49
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

veritascoco

гæ (³õÈëÎÄ̳)

ÒýÓûØÌû:
4Â¥: Originally posted by bcsnow at 2017-12-01 15:16:49
¿´Äãexcel²Ëµ¥ÉÏÃæÓпª·¢¹¤¾ßÒ»Ïî²»£¬Ã»ÓÐÓÒ¼üÔÚ×Ô¶¨Ò幦ÄÜÇøÀïµ÷³öÀ´£¬µã×ó±ßµÄvisual basic ¾Í¿ÉÒÔÁË...

ÕÒµ½ÁË£¬µ«²»ÊǺܶ®±à³Ì£¬Õâ¸öÐèÒª±à³ÌÂ𣿿ÉÒÔÖ¸µ¼Ò»ÏÂÂ𣿷dz£¸Ðл
5Â¥2017-12-01 16:15:26
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

veritascoco

гæ (³õÈëÎÄ̳)

ÒýÓûØÌû:
6Â¥: Originally posted by bcsnow at 2017-12-01 17:22:24
Sub test()'¼òµ¥Ð´Ò»Ï£¬²âÊÔͨ¹ý
k = 6
For j = 1 To 5 'ºó°´ÁÐËÑË÷
For i = 1 To 5 'ÏȰ´ÐÐËÑË÷
If (Cells(i, j) &lt;&gt; 0) Then
Cells(k, 1) = Cells(i, j) 'µÚÒ»ÁеÚkÐпªÊ¼±£´æ
k = k + 1
E ...

ºÃµÄ£¬·Ç³£¸Ðл
7Â¥2017-12-01 18:43:06
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

veritascoco

гæ (³õÈëÎÄ̳)

ÒýÓûØÌû:
6Â¥: Originally posted by bcsnow at 2017-12-01 17:22:24
Sub test()'¼òµ¥Ð´Ò»Ï£¬²âÊÔͨ¹ý
k = 6
For j = 1 To 5 'ºó°´ÁÐËÑË÷
For i = 1 To 5 'ÏȰ´ÐÐËÑË÷
If (Cells(i, j) &lt;&gt; 0) Then
Cells(k, 1) = Cells(i, j) 'µÚÒ»ÁеÚkÐпªÊ¼±£´æ
k = k + 1
E ...

ÄúºÃ£¬»¹ÏëÇë½ÌÕâ¸ö¿ÉÒÔÓñàдһ¸öС³ÌÐòʵÏÖÂ𣿿ÉÒÔÇó½ÌÒ»ÏÂÂð£¿ÒòÊý¾ÝÁ¿´ó£¬Óиö³ÌÐò¿ÉÄܸü·½±ã¡£
vbºÃ¾ÃûÓö¼Íü¼ÇÁË£¬·Ç³£¸Ðл
8Â¥2017-12-12 13:41:51
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

veritascoco

гæ (³õÈëÎÄ̳)

ÒýÓûØÌû:
9Â¥: Originally posted by bcsnow at 2017-12-12 16:48:26
Õ⻹ÄÜÍü£¿°ÑÄã±í¸ñ·¢¸øÎÒÊÔÊÔ¿´...

ºÃµÄ£¬·Ç³£¸Ðл£¬´óѧѧµÄ£¬ºÃ¾ÃûÓÃÁË
10Â¥2017-12-12 17:36:15
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
Ïà¹Ø°æ¿éÌø×ª ÎÒÒª¶©ÔÄÂ¥Ö÷ veritascoco µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 0703 µ÷¼Á +3 ÎÒ¿ÉÒÔÉϰ¶µÄ¶Ô 2026-03-16 6/300 2026-03-23 08:52 by ×íÔÚ·çÀï
[¿¼ÑÐ] Ò»Ö¾Ô¸ÖÐÄÏ´óѧ»¯Ñ§Ñ§Ë¶0703×Ü·Ö337Çóµ÷¼Á +4 niko- 2026-03-22 4/200 2026-03-23 07:56 by Iveryant
[¿¼ÑÐ] 311Çóµ÷¼Á +6 ¶¬Ê®Èý 2026-03-18 6/300 2026-03-22 20:18 by edmund7
[¿¼ÑÐ] Ò»Ö¾Ô¸»ªÖÐũҵ071010£¬×Ü·Ö320Çóµ÷¼Á +5 À§À§À§À§À¤À¤ 2026-03-20 6/300 2026-03-22 17:41 by hxsm
[¿¼ÑÐ] Ò»Ö¾Ô¸ Î÷±±´óѧ £¬070300»¯Ñ§Ñ§Ë¶£¬×Ü·Ö287£¬Ë«·ÇÒ»±¾£¬Çóµ÷¼Á¡£ +3 ³¿»èÏßÓëÐǺ£ 2026-03-20 3/150 2026-03-22 16:00 by ColorlessPI
[¿¼ÑÐ] 384Çóµ÷¼Á +3 ×Óϵ²© 2026-03-22 4/200 2026-03-22 11:04 by ²«»÷518
[¿¼ÑÐ] 0856²ÄÁÏר˶353Çóµ÷¼Á +4 NIFFFfff 2026-03-20 4/200 2026-03-22 09:49 by 2026paper
[¿¼ÑÐ] ×ÊÔ´Óë»·¾³ µ÷¼ÁÉêÇë(333·Ö) +5 holy J 2026-03-21 5/250 2026-03-21 22:42 by Catalysis25
[¿¼ÑÐ] 0703»¯Ñ§297Çóµ÷¼Á +3 Daisy¡î 2026-03-20 3/150 2026-03-21 17:45 by ColorlessPI
[¿¼ÑÐ] 306Çó0703µ÷¼ÁÒ»Ö¾Ô¸»ªÖÐʦ·¶ +5 Ö½Óãly 2026-03-21 5/250 2026-03-21 17:11 by ѧԱ8dgXkO
[¿¼ÑÐ] 279·ÖÇóµ÷¼Á Ò»Ö¾Ô¸211 +14 chaojifeixia 2026-03-19 15/750 2026-03-21 13:24 by zhukairuo
[¿¼ÑÐ] Ò»Ö¾Ô¸ÄϾ©Àí¹¤´óѧ085701×ÊÔ´Óë»·¾³302·ÖÇóµ÷¼Á +4 ¿ûè÷ÎÀ¶Ó 2026-03-18 6/300 2026-03-20 23:02 by JourneyLucky
[¿¼ÑÐ] ¿¼Ñе÷¼ÁÇóÑ§Ð£ÍÆ¼ö +3 ²®ÀÖ29 2026-03-18 5/250 2026-03-20 22:59 by JourneyLucky
[¿¼ÑÐ] ²ÄÁÏÓ뻯¹¤×¨Ë¶µ÷¼Á +7 heming3743 2026-03-16 7/350 2026-03-20 19:31 by zhukairuo
[¿¼ÑÐ] ¹¤¿Æ²ÄÁÏ085601 279Çóµ÷¼Á +7 À§ÓÚÐdz¿ 2026-03-17 9/450 2026-03-20 17:38 by ÎÞи¿É»÷111
[¿¼ÑÐ] Çóµ÷¼Á +3 °µÓ¿afhb 2026-03-16 3/150 2026-03-20 00:28 by ºÓÄÏ´óѧУÓÑ
[¿¼ÑÐ] 0703»¯Ñ§µ÷¼Á +4 18889395102 2026-03-18 4/200 2026-03-19 16:13 by 30660438
[¿¼ÑÐ] ²ÄÁÏÓ뻯¹¤Çóµ÷¼Á +7 Ϊѧ666 2026-03-16 7/350 2026-03-19 14:48 by ¾¡Ë´Ò¢1
[¿¼²©] 26²©Ê¿ÉêÇë +3 1042136743 2026-03-17 3/150 2026-03-17 23:30 by ÇáËɲ»ÉÙËæ
[˶²©¼ÒÔ°] ºþ±±¹¤Òµ´óѧ ÉúÃü¿ÆÑ§Ó뽡¿µÑ§Ôº-¿ÎÌâ×éÕÐÊÕ2026¼¶Ê³Æ·/ÉúÎï·½Ïò˶ʿ +3 1ϲ´º8 2026-03-17 5/250 2026-03-17 17:18 by ber´¨cool×Ó
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û