ªð¦^¦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¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD