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

[µo°Ý] ½Ð°Ý¦bExcelÀÉ¡A­n¦p¦óª¾¹D¤w¸g¦³´X­Ó¤u§@ªí¤Î¨ä¤u§@ªí¦WºÙ?

[µo°Ý] ½Ð°Ý¦bExcelÀÉ¡A­n¦p¦óª¾¹D¤w¸g¦³´X­Ó¤u§@ªí¤Î¨ä¤u§@ªí¦WºÙ?

½Ð°Ý¦bExcelÀÉ¡A¥ÎVBA­n¦p¦óª¾¹D¤w¸g¦³´X­Ó¤u§@ªí¤Î¨ä¤u§@ªí¦WºÙ?
­Y¥i¥Hª¾¹Dªº¸Ü,´N®e©ö§ä¨ì§Ú­nªº¸ê®Æ.

¦^´_ 1# ohsw


¸Õ¸Õ..
MsgBox Sheets.Count  'Åã¥Ü sheet ¼Æ¶q
For i = 1 To Sheets.Count
    MsgBox Sheets(i).Name  'Åã¥Ü¦Usheet¦WºÙ
Next i

TOP

«z¡A§A¯u¬O¤Ó¼F®`¤F!ÁÂÁ¡C

TOP

        ÀR«ä¦Û¦b : ¤H¨ÆªºÁ}Ãø»PµZ¿i¡A´N¬O¤@ºØ¦ÒÅç¡C
ªð¦^¦Cªí ¤W¤@¥DÃD