½Ð±ÐVBA§R°£AÄæ«ü©w"¤¤¤å"¦r¤¸(¦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
![2016µU¦~¥þ¶Ô¼ú³¹ 2016µU¦~¥þ¶Ô¼ú³¹](images/common/hou.gif) ![2015¦Ï¦~¥þ¶Ô¼ú³¹ 2015¦Ï¦~¥þ¶Ô¼ú³¹](images/common/yang.gif) ![¼ö¯P°Ñ»P¾±³¹ ¼ö¯P°Ñ»P¾±³¹](images/common/medal7.gif)
|
¦^´_ 10# jsc0518
¨º´N°µ°Ï°ì§a¡I(with)
With Sheets("¤u§@ªí")
arr = .Range("A1:A" & .UsedRange.Rows.Count + 1)
For I = 1 To UBound(arr)
If d.exists(arr(I, 1)) Then arr(I, 1) = ""
Next I
.[A1].Resize(UBound(arr), 1) = arr
.Columns("A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End With |
|
|
|
|
|
|
- ©«¤l
- 455
- ¥DÃD
- 111
- ºëµØ
- 0
- ¿n¤À
- 563
- ÂI¦W
- 36
- §@·~¨t²Î
- Windows 10
- ³nÅ骩¥»
- Office 2019
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-11-7
- ³Ì«áµn¿ý
- 2025-2-19
![2024¦~¥þ¶Ô¼ú³¹ 2024¦~¥þ¶Ô¼ú³¹](images/common/dragon2024.png) ![2023¦~¥þ¶Ô¼ú³¹ 2023¦~¥þ¶Ô¼ú³¹](images/common/2023.png) ![2022ªê¦~¥þ¶Ô¼ú³¹ 2022ªê¦~¥þ¶Ô¼ú³¹](images/common/hu.gif) ![2021¤û¦~¥þ¶Ô¼ú³¹ 2021¤û¦~¥þ¶Ô¼ú³¹](images/common/niu.gif) ![2020¹«¦~¥þ¶Ô¼ú³¹ 2020¹«¦~¥þ¶Ô¼ú³¹](images/common/shu.gif) ![2019 ½Þ¦~¥þ¶Ô¼ú³¹ 2019 ½Þ¦~¥þ¶Ô¼ú³¹](images/common/zhu.gif) ![2018 ª¯¦~¥þ¶Ô¼ú³¹ 2018 ª¯¦~¥þ¶Ô¼ú³¹](images/common/gou.gif) ![2017 Âû¦~¥þ¶Ô¼ú³¹ 2017 Âû¦~¥þ¶Ô¼ú³¹](images/common/ji.gif) ![½×¾ÂÃÙ§U¾±³¹ ½×¾ÂÃÙ§U¾±³¹](images/common/medal3.gif)
|
¦^´_ 11# lpk187
ÁÂÁ±zªº¦^ÂСA§Ú¦A¸Õ¸Õ |
|
Just do it.
|
|
|
|
|