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

§Ö³t´M§ä¬¡­¶¤¤¬O§_¦³¦X¨ÖÀx¦s®æ

¦^´_ 4# leiru

¨Ï¥ÎVBAªº¸Ü¡A³o­Ó¤èªkµ¹§A°Ñ¦Ò¡C
§A¥i¥H±N³o­Ó¥¨¶°³]©w§Ö±¶Áä¡A
³o¼Ë¨Ï¥Î¤W¥i¯à·|§ó¤è«K¡C
  1. Sub FindMerge()
  2.     Application.FindFormat.Clear
  3.     Application.FindFormat.MergeCells = True
  4.     Cells.Find(What:="", After:=ActiveCell, LookIn:=xlFormulas, LookAt:=xlPart, _
  5.     SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, MatchByte:=False, SearchFormat:=True).Activate
  6. End Sub
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ¤H­nª¾ºÖ¡B±¤ºÖ¡B¦A³yºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD