- ©«¤l
- 9
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 62
- ÂI¦W
- 1
- §@·~¨t²Î
- Window 7
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- »O¥_
- µù¥U®É¶¡
- 2018-10-25
- ³Ì«áµn¿ý
- 2024-5-16
|
[µo°Ý] Cells.Find ¦p¦óÅý§ä¤£¨ì¸ê®Æ®É´N¸õ¹L
¤j®a¦n
¦Û¤v¦b»s§@ªí®æ¬d¸ß®É¡A¹J¨ìCells.Findªº¥Îªk¤£ª¾¹D¦p¦ó¯à°÷¸Ñ¨M¡A
ÁٽЪ©¥»ªº¦U¦ì¯à¤£§[«ü±Ð¡AÁÂÁÂ
»¡©ú¡GªþªñexcelÀɮצ³¨âÓ¶± (¬d¸ß¡BÁ`ªí)¡A·í§â¬Y¤@¨Ç§÷®Æ¸¹½X©ñ¨ì¡y¬d¸ß¡z¶±ªºA2-A16«á¡A
µ{¦¡¥i¥H¥hÁ`ªí§â«á±ªº¸ê®Æ (¥]§t¸ê®Æ¡B´À¥NÃö«Y¡B¥i¥Î¾÷«¬)¡A¶K¨ì¹ïÀ³ªºÄæ¦ì¡C
¥Ø«e¤w¸g¥i¥H°µ¬d¸ßªº¥\¯à¡A¦ý¦pªG¡y¬d¸ßªº¸ê®Æ¡z¦bÁ`ªí¤£¦s¦b´N·|¥X²{¥H¤U¿ù»~¡A
¡y°õ¦æ¶¥¬q¿ù»~ '91':¡z
¡y¨S¦³³]©wª«¥óÅܼƩÎWith°Ï¶ôÅܼơz
¦A½Ð¦U¦ì¨ó§UÀ°¦£«ü¥X°ÝÃD»P¸Ñªk¡AÁÂÁÂ- Sub ´À¥N®Æªí¥Î¸ê§÷¬d¸ß220901()
- '
- Dim find_data, dat_rng, data_end, data_row, CleanFail
- Application.ScreenUpdating = False
- Sheets("¬d¸ß").Select
- Range("B2:BQ16").ClearContents
- For i = 2 To 16
- If Cells(i, "A") = "" Then
- Exit For
- Else
- find_data = Sheets("¬d¸ß").Cells(i, "A")
- Cells(i, "A").Select
- Sheets("Á`ªí").Select
- date_end = Range(Selection, ActiveCell.SpecialCells(xlCellTypeLastCell)).Address
- date_rng = "A1:" & date_end
-
- Cells.Find(What:=find_data, After:=ActiveCell, LookIn:=xlValues, _
- LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
- MatchCase:=False, MatchByte:=False, SearchFormat:=False).Activate
-
- Selection.End(xlToRight).Select
- Selection.Copy
- Sheets("¬d¸ß").Select
- Cells(i, "A").Select
- ActiveCell.Offset(0, 1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
- :=False, Transpose:=False
- Sheets("Á`ªí").Select
- Selection.End(xlToRight).Offset(0, 1).Select
- Selection.Copy
- Sheets("¬d¸ß").Select
- ActiveCell.Offset(0, 1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
- :=False, Transpose:=False
- Sheets("Á`ªí").Select
- Selection.Offset(0, 2).Select
- Range(Selection, Selection.End(xlToRight)).Copy
- Sheets("¬d¸ß").Select
- ActiveCell.Offset(0, 1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
- :=False, Transpose:=False
- End If
- Next
- Cells(ActiveWindow.ActivePane.ScrollRow, ActiveWindow.ActivePane.ScrollColumn).Select
- Application.ScreenUpdating = True
- End Sub
½Æ»s¥N½X |
-
-
CUT.JPG
(134.13 KB)
-
-
¸ÕÅç®Æªíup.rar
(36.75 KB)
´À¥N
|