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

[µo°Ý] ½Ð±ÐÃö©ó¦C¦L½d³ò°ÝÃD(Àx¦s®æ¨S¦³¸ê®Æ¤£¦C¦L)

[µo°Ý] ½Ð±ÐÃö©ó¦C¦L½d³ò°ÝÃD(Àx¦s®æ¨S¦³¸ê®Æ¤£¦C¦L)

³Ìªñ­è§¹¥þ¤@­Ó¤u§@ªí
¨ä¤u§@Àx¦s®æ¦C¦L½d³ò¦p¤U
A1~A100
A1~K1
³£¬O¦³¹ºªí®æªº

¦pªGÀx¦s®æªº¸ê®Æ¥u¦³¨ìA1~A50¡BA1~K1
¸Ó«ç»ò³]­p¦Û°Ê¦C¦L¨ì¦³¸ê®Æªº½d³ò©O?

¦]¬°³æ¯Â«ö¦C¦Lªº¸Ü
¦C¦Lªº½d³ò·|³sA51~A100¡BA1~K1¦³¹º¦nªºªÅ¥ÕÀx¦s®æ¤]¤@¨Ö¦C¦L¥X¨Ó
(Àx¦s®æ¸Ì¬O¨S¦³¸ê®Æªº)

¤u§@ªíªº¤À­¶¦@¦³12±i(1¤ë¨ì12¤ëªº)
©Ò¥H¨C±i¤u§@ªíªº¸ê®Æ©T©w³£¬OA1~A100¡BA1~K1
¦ý¨C±i¤u§@ªíªºÀx¦s®æ¸ê®Æ¤£¤@©w³£¬O©T©wªº

¤£ª¾¹D¦³¤°»ò¤è¦¡¥i¥H¸Ñ¨M¦C¦Lªº°ÝÃD¶Ü?
ÁÂÁÂ

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2016-1-22 13:09 ½s¿è

¤èªk¢°¡G
¨Ï¥Î¡e°ÊºA½d³ò¡fªº¡e©w¸q¦WºÙ¡f¡G
¦WºÙ¡GPrint_Area
¤½¦¡¡G=INDIRECT("A1:K"&COUNTA(INDIRECT("A:A")))¡@

¨C¤@¤u§@ªí³]¤@¦¸¡ã¡ã¥i¥Î¡e½Æ»s¡f¡A«ö¡eCtrl + V¡f¶K¤W

¤èªk¢±¡G
¦b¡e¬¡­¶Ã¯¨Æ¥ó¡f¤¤¶K¤J¥H¤Uµ{¦¡¡G
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Range("A1:K" & [A65536].End(xlUp).Row).Name = "'" & ActiveSheet.Name & "'!Print_Area"
End Sub
¡@
¡@

TOP

¤èªk¢°¡G
¨Ï¥Î¡e°ÊºA½d³ò¡fªº¡e©w¸q¦WºÙ¡f¡G
¦WºÙ¡GPrint_Area
¤½¦¡¡G=INDIRECT("A1:K"&COUNTA(INDIRECT ...
­ã´£³¡ªL µoªí©ó 2016-1-22 13:03


­è­è§â¦¹¤½¦¡®M¨ì­ì¨Ó¤u§@ªí¬OOKªº
¦pªG­ì¨Óªº¤u§@ªí¤W
¦b©w¸q¦WºÙºÞ²z¸Ì
­Y¤w¸g¥ý¦s¦b¤@­Ó
Print_Titles
='¤u§@ªí1'!$8:$8
³o­Ó¦³¿ëªk¨Ã¦s¶Ü?

¦]¬°$8:$8³o³¡¥÷
¤w¸g¦³¥ý³]©w¦C¦L¼ÐÃD¦C¸Ì¥h¤F

©Ò¥H­Y¸ê®Æ¨ì¦¸­¶
8¦C³£¬O©T©w¥X²{¦b³Ì¤W­±

µM«á1~7¦C³£¬O©T©w¤½¦¡¥X²{µ²ªG¥Îªº

9¦C¤§«á¤~¬O¿é¤J¸ê®Æ¨Ï¥Î
(A1~A100³£¦³¤½¦¡¦s¦b¡A¬O°µ¬y¤ô¸¹¤½¦¡¥Îªº =IF(A9="","",ROW()-8))

³o¼Ë¦A·s¼W¤@­Ó©w¸q¶i¥h·|¦³¼vÅT©Î¸Ó«ç»ò­×§ï©O?
ÁÂÁÂ

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2016-1-23 12:10 ½s¿è

¦^´_ 3# hairyhead


¡ePrint_Titles¡f»P¡ePrint_Area¡f¨Ã¤£½Ä¬ð¡A

¢ÏÄæ­Y¬°¯Â¼Æ¦r¡A¥B¬°¡e¼Æ­È®æ¦¡¡f¡A
¤½¦¡§ï¬°¡G=INDIRECT("A1:K"&MATCH(9E+307,INDIRECT("A:A")))

¨S¦³ÀɮסAµLªk§P©w¯u¥¿ªº¦C¦L¨ç»\½d³ò¡A°ò¥»ªí®æ¥i¯à¥]§t¡eªí­º¡D¼ÐÃD¦C¡D¸ê®Æ°Ï¡f¡I

TOP

¥»©«³Ì«á¥Ñ hairyhead ©ó 2016-1-23 15:15 ½s¿è

­è­è¸Õ¤F¤@¤U
TITLES¡BAREA ³o2­Ó¤£½Ä¬ð«á­±´N¨S¦³°ÝÃD¤F
·PÁ¸ѵª

TOP

¦^´_ 4# ­ã´£³¡ªL

½Ð°Ý¿z¿ï«á Á׶}ªÅ®æ¡A¦ý¬OÁÙ¬OµLªk¨ú®ø ªÅ¥Õ­¶
¥i¥HÀ°§Ú¬Ý¬Ý¶Ü?

http://www.funp.net/951232

ªþÀÉ®×

TOP

        ÀR«ä¦Û¦b : ¦Y­W¤F­W¡B­WºÉ¤Ü¨Ó¡A¨ÉºÖ¤FºÖ¡BºÖºÉ´d¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD