[¤À¨É] ¤À¨É

mhl9mhl9

¥H¤UTest,°õ¦æ¤@¦¸,activesheet­^¤å¥þ³¡§ï¬°"¤j·¢,¦A°õ¦æ¤@¦¸­^¤å¥þ³¡§ï¬°"¤p·¢"
Sub LUcase(A As Boolean)
Dim R As Range
Dim R1 As Range
Dim R2 As Range
Dim cell As Range
Dim cell1 As Range

For Each cell In ActiveSheet.UsedRange.Areas
    Set R1 = cell.Resize(, 1)
    Set R2 = cell.Resize(1)
    If A = True Then
        cell = Evaluate("IF(ROW(" & R1.Address & "),iF(COLUMN(" & _
            R2.Address & "),upper(" & cell.Address & ")))")
    Else
        cell = Evaluate("IF(ROW(" & R1.Address & "),iF(COLUMN(" & _
            R2.Address & "),lower(" & cell.Address & ")))")
    End If
Next cell
End Sub

Sub test()
Static A As Boolean
LUcase A
A = Not A
End Sub

mhl9mhl9

GBKEE,ÁÂÁ´£¨Ñ²©ö¤èªk,«Ü¦n¥Î,¦ýusedrange«Ü¤j®É«ÜºC(§Úªº­Ó®×110000¦æ¸ê®Æ),ÁÙ¬OÁÂÁÂ

GBKEE

¦^´_ 1# mhl9mhl9
²¤Æ¤@¤U

1. Option Explicit
   
2. Sub Ex()
   
3.      Dim E As Range
   
4.      Static A As Boolean
   
5.      For Each E In ActiveSheet.UsedRange.SpecialCells(xlCellTypeConstants)
   
6.         E = IIf(A, UCase(E), LCase(E))
   
7.      Next
   
8.      A = Not A
   
9. End Sub

½Æ»s¥N½X