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

[µo°Ý] ¦p¦ó¼gµ{¦¡¦b¨C3¦C®É¹º¤@±øµê½u?

[µo°Ý] ¦p¦ó¼gµ{¦¡¦b¨C3¦C®É¹º¤@±øµê½u?

¦pªþÀÉ¡AÁÂÁ¡C Book111.rar (6.71 KB)

Sub yy()
For i = 2 To [a65536].End(3).Row Step 3
Cells(i + 2, 1).Resize(, 5).Borders(9).LineStyle = xlDash
Next
End Sub

TOP

ÁÂÁÂoobird¤j¤j¡A§Ú¨Ó¬ã¨s¬Ý¬Ý! ¥t¥~¡A§Ú¬Ovbaªì¾ÇªÌ¡A½Ð±z¬O§_¥i¥H«Øij§Ú¡A¦p¦óÂǥѦ¹ºô¯¸¾Ç²ß°ò¦ªº§Þ¥©? ÁÂÁ±z~

TOP

¦h¬Ý¡B¦h°Ý¡B¦h¼g
¨S¦³³o¤T¦h¡A´N¨S¦³¶i¨B¡C

TOP

¬Oªº¡AÁÂÁÂoobirdªº«üÂI¡A·PÁÂ~

TOP

Cells(1).Resize(, 100).Borders(9).LineStyle = xlDouble
¥H¤W«ü¥O¥u¯àÅã¥Ü²Ä¤@¦C©³¤Uªº½u¡A¦p¦ó¦b²Ä¤@¦C¤W¤è¤]¥X²{Âù±ø½u? (§Ú¼W¥[cell(0)¬O¿ù»~ªº)

TOP

Cells(1).Resize(, 100).Borders(8).LineStyle = xlDouble

TOP

«¢¡A­ì¨Ó¬OBordersªº°ÝÃD¡A¤S¾Ç¤F¤@©Û¡AÁÂÁ¤j¤j!

TOP

¤j¤j¡A½Ð°Ý­Y¥t¥~­n¥[¨C¤@­¶²Ä25µ§ªº¤U¤è¥Ñµê½u§ï¬°¤@±ø¹ê½u(²Ä¤@­¶À³¥[ªíÀY¡A¬G¬°²Ä26µ§)¡A¨º¸Ó¦p¦ó­×§ï?

TOP

For i = 2 To [a65536].End(3).Row Step 25
Cells(i + 24, 1).Resize(, 5).Borders(9).LineStyle = 1
Next

TOP

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