ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

²M°£«ü©w½d³ò¬õ¦â¼Æ¦r°ÝÃD

¦^´_ 3# msmplay
  1. Sub Ex()
  2.     Application.FindFormat.Font.colorIndex = 3
  3.     Range("A20:K100").Replace What:="*", Replacement:="", LookAt:=xlPart, SearchOrder:= _
  4.         xlByRows, MatchCase:=False, SearchFormat:=True, ReplaceFormat:=False
  5. End Sub
½Æ»s¥N½X
¥H«á­n§ó§ï½d³ò
´N§ó§ïRANGE( ) ¸Ì­±ªº³¡¤À´N¥i¥H¤F
PKKO

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD