vba ¤ñ¹ïÀx¦s®æ½d³ò¤º¦r¦ê¨ÃÂà¸m«á¥[¤J¦r¤¸
- ©«¤l
- 51
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 73
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2015-7-28
- ³Ì«áµn¿ý
- 2015-12-17
|
vba ¤ñ¹ïÀx¦s®æ½d³ò¤º¦r¦ê¨ÃÂà¸m«á¥[¤J¦r¤¸
¤j®a¦n¡A¤p©f¦]¤u§@Ãö«Yè¾Ç²ßvba
¨Ï¥Îª©¥»¬°2003
¿ý»s¥¨¶°«á±o¨ì¥H¤Uµ{¦¡
Range("C10:H10").Select
ActiveCell.FormulaR1C1 = "=TRANSPOSE(º¶!R14C2:R34C2)"
Selection.FormulaArray = "=TRANSPOSE(º¶!R14C2:R34C2)"
§Ú·Q§ï¦¨§Ú»Ýnªº±ø¥ó
1.C13:AB13Àx¦s®æ¤¤Y¦³"Hz"ªº¦r¦ê¡A«h¦b¨º¤@¦C¤¤¸ÓÀx¦s®æ§t¦³°õ¦æÂà¸mªº°Ê§@(µù¡Gº¶!R14C2:R34C2¤º¬°©Ò³]©w¦nªº¸ê®Æ¡A¦³¥]§tªÅ¥Õ)¡AY¸ÓÀx¦s®æ¤º¨S¦³"Hz"ªº¦r¦ê«h¤£»Ýn¸g¹LÂà¸m
2.°õ¦æÂà¸m«á¡A¦³¸g¹LÂà¸mªºÀx¦s®æ¡A°£¤FC¦Cªº²Ä¤@®æ¥~³£n¥[¤J"CL :"
¤j·§ª¾¹Dn¨Ï¥Îfor »Pif then¡A¥i¬O¤p©fè¾Ç²ßvba¡AÁÙ¤£ª¾¹D«ç»ò°Â°_¨Ó
¤£ª¾¹D¸Ó«ç»ò¤U¤â¥h¾Ç²ß³o¼Ëªº»y¨¥¡A¯S¨Ó½Ð±Ð¦U¦ì¤j¤j¡A·PÁ¡C |
|
|
|
|
|
|
- ©«¤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
|
¦^´_ 1# t591nm
¤è«K¤W¶ÇÀɮ׶ܡH§_«h«ÜÃø²z¸Ñ§Aªº°ÝÃD |
|
|
|
|
|
|
- ©«¤l
- 51
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 73
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2015-7-28
- ³Ì«áµn¿ý
- 2015-12-17
|
|
|
|
|
|
|
- ©«¤l
- 51
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 73
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2015-7-28
- ³Ì«áµn¿ý
- 2015-12-17
|
¦^´_ 4# GBKEE
¦p¹Ï©Ò¥Ü¥X²{(¤W±¤@±i¤U±¤@±i)
§Ú¥u¬O§ï¤F¥¨¶°¦WºÙ¤Î¦Cªº½d³ò¦Ó¤w
½Ð°ÝSheet2 ¬O«ü¸Ó¤u§@ªí¦WºÙ¶Ü
¨º¦pªG§Úªº¤u§@ªí¦WºÙ¬O¼Æ¦r¥[^¤å
¬O§_¤]¥i¥H§âSheet2ª½±µ§ï¦¨¼Æ¦r¥[^¤å
·PÁ¦^µª |
|
|
|
|
|
|
- ©«¤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
|
¥»©«³Ì«á¥Ñ lpk187 ©ó 2015-7-28 16:26 ½s¿è
¦^´_ 5# t591nm
¥i¨Ì¾Ú¤U¹Ï¨Ò¤l§ó§ï§AªºSheet?
|
|
|
|
|
|
|
- ©«¤l
- 51
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 73
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2015-7-28
- ³Ì«áµn¿ý
- 2015-12-17
|
¦^´_ 6# lpk187
·P®¦¤j¤j
¤w¸g¦¨¥\
ÁÂÁ±z |
|
|
|
|
|
|