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

Excel ÂI¿ï¥ô¤@Àx¦s®æ¡A¥H«ö¶s¿z¿ïµ²ªG

  1. Private Sub CommandButton1_Click()
  2.     If Cells.SpecialCells(12).Rows.Count = 65536 Then
  3.         Set Rng = Range([a2], [f65536].End(3)).ColumnDifferences(Selection)
  4.         Rng.EntireRow.Hidden = True
  5.     Else
  6.         Cells.EntireRow.Hidden = False
  7.     End If
  8. End Sub
½Æ»s¥N½X
a.gif

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD