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

¦X¨ÖÀx¦s®æ

¦X¨ÖÀx¦s®æ

¦p¦ó¥Hµ{¦¡½X´¡¤J¦X¨ÖÀx¦s®æ©O¡H¡H
Ä_Ä_

¦^´_ 1# caichen3

Range("C1:E5").MergeCells = True

TOP

°²³]¥ý´¡¤J¤@¦C¡A¨Ã¥B·Q·s´¡¤Jªº¦C¬O¦X¨ÖÀx¦s®æ
now=Selection.Row
ActiveSheet.Rows(now).Insert
range("   ")

range¤ºªºÅܼƧڸӦp¦ó¼g©O¡H
ÁÂÁ³á¡I
Ä_Ä_

TOP

¦^´_ 3# caichen3
­nª¾¹D§A­n¦X¨Ö´X¦C´XÄæ?
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ caichen3 ©ó 2012-3-12 15:03 ½s¿è

°²¨Ï§Ú³]©w«ö¤@¦¸«ö¶s¡A´¡¤J¤@¦C¨Ã¥B¦X¨Ö7¦æªºÀx¦s®æ©O¡HÁÂÁ¡I
Ä_Ä_

TOP

¦^´_ 5# caichen3

Selection.EntireRow.Insert
Range("A" & Selection.Row).Resize(1, 7).MergeCells = True

TOP

¦^´_ 6# register313


    «ö·Ó¤W­±ªºµ{¦¡½X¡A±N·|¦X¨Ö¥ª¤è¤C¦CÀx¦s®æ¡A½Ð°Ý¯à³]©w¦X¨Ö¥ªÃä/¥kÃ䪺Àx¦s®æ¶Ü??

TOP

¦^´_ 7# jean0165

¦X¨Ö°Ê§@ªºµ{¦¡½X¥²¶·¤F¸Ñ§Aªº°ò·ÇÂI¦b­þ?
³o¬O¦p¦ó¨ú±o¦X¨Ö½d³òªº¥²­n±ø¥ó
°ÝÃD°Ý±o¤Ó¹LªÅ¬}¡A±o¤£¨ì¥¿½T¸Ñµª
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 7# jean0165

³]G10¬°­ì°ò·ÇÀx¦s®æ

Range([G10], [G10].Offset(a, b)).MergeCells = True
a:¼Æ­È,a¬°¥¿:ªí©¹¤UÂX®i¤§®æ¼Æ,a¬°­t:ªí©¹¤WÂX®i¤§®æ¼Æ
b:¼Æ­È,b¬°¥¿:ªí©¹¥kÂX®i¤§®æ¼Æ,b¬°­t:ªí©¹¥ªÂX®i¤§®æ¼Æ

TOP

¦^´_ 9# register313


    ÁÂÁ§Aªº¦^ÂÐ!!

TOP

        ÀR«ä¦Û¦b : §Ú­Ì³Ì¤jªº¼Ä¤H¤£¬O§O¤H¡D¥i¯à¬O¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD