[µo°Ý] ¦V¥k´M§ä³Ì«á¤@®æ¦³®æ½uªºÀx¦s®æ

alex520188

¦U¦ì¤j¤j¦n

¦V¥k´M§ä³Ì«á¤@®æ¦³"µe®æ½u"ªºÀx¦s®æ »yªk­n«ç¼g
sub 123()
Dim L%
L = Range("A9").End(xlToRight).Borders.LineStyle
end sub

³o¼Ë¦n¹³¤£¤Ó¹ï

请¤j¤j«ü±Ð¤F^*^

kimbal

sub 123()
    Dim L%
    For Each c In Range(Range("A9"), Range("A9").End(xlToRight))
        If c.Borders.LineStyle <> xlNone Then
            L% = c
        End If
    Next
end sub

¤U­±ªº½ÆÂø¤@¨Ç¦ý·|§Ö¤Ö³\
Sub test()
    Dim L%
    Dim i
    With Range(Range("A9"), Range("A9").End(xlToRight))
        For i = .Cells.Count To 1 Step -1
            If .Cells(i).Borders.LineStyle <> xlNone Then
                L% = .Cells(i)
                Exit For
            End If
        Next
    End With
End Sub

smouse0220

1. X=worksheets(1).cells(1,256).end(xltoleft).column

½Æ»s¥N½X

§A¥i¥H°Ñ¦Ò¤W­zªºµ{¦¡½X

­n­pºâ±q¥k¨ì¥ª ©Î¬O ±q¥ª¨ì¥k ªº°ÝÃDÂI
¬O¥d¦b¡yRange¡A©Ò¥H­n§ï¥ÎCells¤ñ¸û¤è«K¡z
­ì¦]¬O¤j®a³£ª¾¹DExcel ³Ì¦h¯à°÷65536 ¦æ
¨º³Ì¦h´X¦C©O?
µª®×¬O256¦C
¨º¦pªG256¦CÂà´«¦¨range..¦³ÂI§xÃø

©Ò¥H§Ú¥ÎCells(1,256).end(xltoleft).column
­pºâ²Ä¤@¦æ±q¥k¨ì¥ª¡A²Ä¤@­Ó¦³¦r¦êªº¦C¼Æ

oobird

1. Sub FindFormatDemo()
   
2.     Application.FindFormat.Borders.LineStyle = 1
   
3.     Set c = Rows(9).Find(What:="", After:=[a9], SearchOrder:=2, SearchDirection:=2, SearchFormat:=True)
   
4.     If Not c Is Nothing Then MsgBox c.Address
   
5.     End Sub

½Æ»s¥N½X