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

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

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

¦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 ©ó 2012-7-18 22:21 ½s¿è

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
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¥»©«³Ì«á¥Ñ smouse0220 ©ó 2012-7-31 23:46 ½s¿è
  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¼Æ

TOP

  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

TOP

        ÀR«ä¦Û¦b : ®É®É¦n¤ß´N¬O®É®É¦n¤é¡C
ªð¦^¦Cªí ¤W¤@¥DÃD