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

[µo°Ý] VBA¡A¬ðµM¤@®ÉÂण¹L¨Ó

  1. Sub ex()
  2. Columns("A").SpecialCells(xlCellTypeBlanks).Delete Shift:=xlUp
  3. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD