¦p¦ó¥Ñ¬YÄæ¸õ¨ì§OÄæ,¦A¦^¨ììÄæ?
- ©«¤l
- 35
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 43
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- WIN
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2015-9-13
- ³Ì«áµn¿ý
- 2019-12-16
|
¦p¦ó¥Ñ¬YÄæ¸õ¨ì§OÄæ,¦A¦^¨ììÄæ?
°²³]ì©w¦ì¸m¬OA5,µM«á¸õ¨ì¦P¦CªºDÄæ,§YD5,
·í°µ§¹¤@¨Ç°Ê§@«á,¦ì¸mÅܦ¨D18,·Q¸õ¦^¸Ó¦CªºAÄæ,§YA18,
¦³¥i¯à³o¼Ë¼g¶Ü?ÁÂÁ¤F!!:) |
|
|
|
|
|
|
- ©«¤l
- 406
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 453
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2015-2-7
- ³Ì«áµn¿ý
- 2021-7-31
|
¦^´_ 1# leehom
ÃD·N¤£°÷²M´·¡AY¦³¹Ï»¡©ÎªÌªþ¥ó·|§ó¦n¡A¤£µM¤]¥u¯à¥Î²qªº¡C
§Ú¥u¯à¥ý°²³]§Aªº¦ì¸m©w¸q¬O"±Ò¥Î"ªºÀx¦s®æ¡A°Ñ¦Ò¬Ý¬Ý§a¡C
Cells(ActiveCell.Row, "A").Activate |
|
|
|
|
|
|
- ©«¤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# leehom
¸Û¦p2¼Ó©Ò»¡ªº¡AÃD·N¤£²M´·
§AÀ³¸Ó¦h¬ÝVBE¤¤ªºRangeªº»¡©ú©Î¬O³o½×¾Â¤¤ªº¤å³¹¡A
¦]¬°§A©Ò°Ýªº¡A³£¬O³Ì°ò¦ªºª¾ÃÑRange¡BCells¡BRow¡BColumn¥un·d²M·¡³o´XÓ§Aªº°ÝÃD´N¥i¥HÀH·N¹B¥Î¤F
Range¡G½d³ò¡A³æ¤@Àx¦s®æ¥H¤W¬Û¾FªºÀx¦s®æ¼g¦¨Range("A1:A10")©Î²ºÙ[A1:A10]¨ä»yªk·N«ä¬°¡A±qA1¨ìA10
Cells¡GÀx¦s®æ©Î³æ¤¸®æ¡A´N¬O³æ¤@ÓÀx¦s®æ©Î¥Nªí¤u§@ªí©Ò¦³Àx¦s®æ¡A³æ¤@Àx¦s®æ¼gªk ¥HB1Àx¦s®æ¨Ó»¡©ú ¡A¼gªk¬°Cells(1,2)·N«ä´NCells(¦C1,Äæ2)ªº·N«ä¡A©Ò¦³Àx¦s®æ«h¥u¼g¦¨ Worksheet.Cells
Row¡G¦C¸¹¡Aþ¤@¦Cªº·N«ä
Column¡GÄ渹¡Aþ¤@Äæ
¥H¤W»¡©ú¡A¥u¬O²³æ´yz¡A¨Ã¤£¯à°÷¥Nªí©Ò¦³·N«ä¡A¸Ô²Ó»¡©ú¡AÀ³¥HVBE»¡©ú¬°¥D
¤U±¥N½X¥u¬O¸ÑÄÀ§Aªº°ÝÃDªº´yz ªº°ò¦»yªk¡A¨ä¹ê»Ú¼gªk¤´n¬Ý§Aªº°µ¥ÎË©³¬O¤°»ò¦Ó©w¡G
Dim Ran As Range
Set Ran = Range("A5") '°²³]ì©w¦ì¸m¬OA5¡AA5³]¦¨ÅÜ¼Æ Ran
Cells(Ran.Row, "D").Select 'µM«á¸õ¨ì¦P¦CªºDÄæ,§YD5¡A³o¸Ì¤£ª¾¹D§An°µ¤°»ò¨Æ¡A©Ò¥H¥u¦³¥ÎSelect¿ï¾Ü D5¡AY¬On¼gÈ¥i¥H¼g¦¨ Cells(Ran.Row, "D")="ABC"
Cells(18, "D").Select '·í°µ§¹¤@¨Ç°Ê§@«á , ¦ì¸mÅܦ¨D18 ¡A¦P¤W¦C»¡©ú
Cells(18, Ran.Column).Select '¸õ¦^¸Ó¦CªºAÄæ,§YA18 |
|
|
|
|
|
|
- ©«¤l
- 35
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 43
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- WIN
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2015-9-13
- ³Ì«áµn¿ý
- 2019-12-16
|
¦^´_ 3# lpk187
·PÁ¼ӤW¨â¦ìªº¼ö¤ß¸Ñµª,¨ä¹ê§Ú¬O·Q³o¼Ëªº
¦p¤W¹Ï©Ò¨£,DÄ檺¸ê®Æ¨ìD395,§Ú·QA,B,CÄæ¯à¦Û°Ê¦V¤U½Æ»s,AÄæ¥ÑA388½Æ»s30-Oct¨ìA395,BÄæ¥Ñ B389½Æ»s12:37¨ìB395,CÄæ¤]¬O¤@¼Ë!³o¼Ë´N¯à¶ñº¡ªÅ¥Õ¡C
¤ñ¦pB381,§Ú¥i¥H¥ý½Æ»s10:43,µM«á§Q¥ÎRange(Selection, Selection.End(xlDown)).Select«ü¥O¨ìB389¦A©¹¤W½Æ»s¥H¶ñº¡, ¦ýB389¤§«á,¦]¤U±¦A¨S¦³¸ê®Æ,¦A©¹¤U´N¬O¥½ºÝ¤F,©Ò¥H·Q¨ì¸õ¨ìDÄæ,µM«á§ä³Ì«á¤@¦C§YD395,µM«á¦A§Q¥Î«ü¥O¦^¨ì¸Ó¦CªºBÄæ,§YB395,´N¥i¥H©¹¤W½Æ»s¤F¡C¦]¬°¤£À´¤ÓÁ}¨¯½Æ»sªº¼gªk,´N·Q¨ì³o»ò¤@¨B¤@¨B¨Ó¼g¤F,©ÎªÌ¦³¬Æ»ò§ó¦nªº¤èªk?½Ð«ü±Ð,ÁÂÁ¤F!! |
|
|
|
|
|
|
- ©«¤l
- 35
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 43
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- WIN
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2015-9-13
- ³Ì«áµn¿ý
- 2019-12-16
|
¦^´_ 4# leehom
¹Ï¤ù³Æ¥÷ |
|
|
|
|
|
|
- ©«¤l
- 406
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 453
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2015-2-7
- ³Ì«áµn¿ý
- 2021-7-31
|
¥»©«³Ì«á¥Ñ n7822123 ©ó 2015-11-1 17:26 ½s¿è
¦^´_ 5# leehom
ª¾¹D§An·F³Â¤F¡A³o¬qµ{¦¡½X¸Õ¬Ý¬Ý§a¡A
¨ä¹ê³oӥΤâ°Ê´N¥i¥H°µªº¨ì¤F¡A¬D¿ï¯S®íÀx¦s®æ(ªÅ®æ)¡AµM«á¿é¤J¤½¦¡=¤W¤@ÓÀx¦s®æ¡A¦A«öCTRL+ENTER- Sub ¦V¤U¶ñº¡()
- [D381].CurrentRegion.SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=R[-1]C"
- With [D381].CurrentRegion
- .Copy
- .PasteSpecial Paste:=xlPasteValues
- End With
- [A1].Select
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 406
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 453
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2015-2-7
- ³Ì«áµn¿ý
- 2021-7-31
|
|
|
|
|
|
|
- ©«¤l
- 35
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 43
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- WIN
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2015-9-13
- ³Ì«áµn¿ý
- 2019-12-16
|
¦^´_ 7# n7822123
ÁÂÁ°Ú,¦ý¤â°Ê¨ºÓ¤£ª¾¹D¬°¬Æ»ò«öCTRL+ENTER¨S¦³¤ÏÀ³? :o |
|
|
|
|
|
|
- ©«¤l
- 406
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 453
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2015-2-7
- ³Ì«áµn¿ý
- 2021-7-31
|
¦^´_ 8# leehom
¿é¤J§¹¤½¦¡¤§«á¡A¤£nÂ÷¶}¿é¤JªºÀx¦s®æ¡A¦A«öCtrl+Enter |
|
|
|
|
|
|