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

[µo°Ý] ½Ð°Ýlistbox²M³æ­nshow¥X©Ò¦³sheet¨Ã±Æ°£«ü©wsheet

¦^´_ 1# lifedidi
  1. Dim XY As Worksheet, j As Variant
  2. For Each XY In Sheets
  3.      j = XY.Name
  4.     if j<>"A" and j<>"C" then ListBox1.AddItem j
  5. Next
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD