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

[µo°Ý] Excelªº¤u§@ªí¬O§_¥i¥Î¦¨ªº¸ê®Æ§¨¼Ë¦¡°µ¤ÀÃþ

[µo°Ý] Excelªº¤u§@ªí¬O§_¥i¥Î¦¨ªº¸ê®Æ§¨¼Ë¦¡°µ¤ÀÃþ

½Ð°Ý¤j¤j¡AExcelªº¤u§@ªí¬O§_¥i¥Î¦¨ªº"¸ê®Æ§¨"¼Ò¦¡°µ¤ÀÃþ

¨Ò¦p:  A(¤u§@ªí)¡BB(¤u§@ªí) ¡BC(¤u§@ªí)---->ÂkÃþ¦b¦P¤@­ÓD(¤u§@ªí)¤º
          E(¤u§@ªí)¡BBF(¤u§@ªí) ¡BG(¤u§@ªí)---->ÂkÃþ¦b¦P¤@­ÓH(¤u§@ªí)¤º....¥H¦¹Ãþ±À

­«ÂI³o¨Ç¤u§@³£¬O¦P¤@­ÓExcel¤§¤¤

¤p§Ì§Úı±o¶}¦h­ÓExcel·Pı«D±`³Â·Ð¡A¤]¤£¯à§Ö³t¹ï·Ó¡A¨C¦¸­n¹ï·Ó´N­n¤Á´«¨ä¥LExcelªí
½Ð¦U¦ì¤j¤jÀ°¦£¡AÁÂÁÂ

©È¤j¤j­Ì¤£¤ÓÀ´§Úªº·N«ä¡A§Ú°µ¤F¤@­Ó¹Ï¤ù¥Ü·N¹Ï

¦pªG¨S¿ìªk½Ð¤j¤j­Ìµ¹­Ó¦^À³¡AÅý§Ú¦º¤ß:'(

TOP

DEAR SIR
¥Î VBA
°²¦p XXX=SHEET4¤u§@ªí. ©óSHEET4¼W¤@¥\¯àÁä°õ¦æ¦p¤U.
¦Û¦æÅÜ´«À³¥Î

Sub ¶}±ÒSHEET123()
Sheet4.Visible = FALSE 'XXX¤u§@ªíÃö³¬
Sheet1.Visible = True   'SHEET1¤u§@ªí¶}±Ò
Sheet2.Visible = True   'SHEET2¤u§@ªí¶}±Ò
Sheet3.Visible = True   'SHEET3¤u§@ªí¶}±Ò
SHEET1.SELECT          '¦Ü'SHEET1¤u§@ªí
RANGE("A1").SELECT    '¦ÜA1Àx¦s®æ
End Sub
ù

TOP

¦^´_ 3# rouber590324


    rouber¤j¤j¡A§Ú§â§A¤W­±ªºµ{¦¡½X¥´¦bVBA¥X²{¤U¹Ï


§Ú¨ä¹ê¨Ã¨S¾Ç¹Lexcelªíªº¥\¯à¡A©Ò¥H°µµ{¦¡¤]¤£·|¡A¥i¥H³Â·Ð¤j¤j¥i¥H°µ¤@²Õ¼Ò²ÕÅý§Ú¨Ï¥Î
½Ð³Â·Ð§âÀÉ®×±H¨ì§Úªº«H½c:[email protected]

TOP

DEAR SIR
¦]§ÚµLªk¤W¶ÇÀÉ®×.µLªk´£¨Ñ½d¨Ò
±z¥Î  ¿ý»s¤è¦¡²£¥Í ¥¨¶°¬Ý¬Ý   ¦A¥Î«ö¶s °õ¦æ¸Ó¥¨¶°
ù

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD