- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
        
|
On Error Resume Next µ{¦¡¤¤·|¤£©ö°£¿ù- Sub Ex()
- If [COUNTA(A1:A8)] <> [A1:A8].Count Then [A1:A8].SpecialCells(xlCellTypeBlanks) = 0
- '¤u§@ªí¨ç¼Æ COUNTA(A1:A8) : pºâ½d³ò¤º¦³¸ê®Æªº¼Æ¥Ø
- '[A1:A8].Count VBA:Count ÄÝ©Ê ¶Ç¦^¤@Ó Long (ªø¾ã¼Æ)¡Aµ¥©ó¦b¤@Ó¶°¦Xª«¥ó¤¤ªºª«¥ó¼Æ¥Ø¡C°ßŪ¡C
- 'SpecialCells ¤èªk ¶Ç¦^Range ª«¥ó¡A¦¹ª«¥ó¥Nªí»P«ü©w«¬ºA¤ÎȬ۲ŦXªº©Ò¦³Àx¦s®æ¡CRange ª«¥ó¡C
- End Sub
½Æ»s¥N½X |
|