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

[µo°Ý] ¦p¦ó¨ú¥N¦r¦ê¤¤ªº"*"

[µo°Ý] ¦p¦ó¨ú¥N¦r¦ê¤¤ªº"*"

¦p¦ó¨ú¥N¦r¦ê¤¤ªº"*",¦p"¤¤°ê*¤H¥Á"¨ú¥N¬°"¤¤°êªº¤H¥Á"
lmh

¦^´_ 1# mhl9mhl9

~*
   
  1. Option Explicit
  2. Sub Ex()
  3.     Dim F As Range
  4.     Set F = Cells.Find("*~**")

  5.     If Not F Is Nothing Then
  6.         Do
  7.             F = Replace(F, "*", "ªº")
  8.             Set F = Cells.FindNext(F)
  9.         Loop Until F Is Nothing
  10.     End If
  11. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

[a:a].Replace "~*", "ªº", Lookat:=xlPart

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD