Created
April 8, 2011 06:25
-
-
Save yusuiked/909390 to your computer and use it in GitHub Desktop.
Excelでデータが存在している最終行から上方に向かって走査して、処理する
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sub procedureName() | |
Dim row As Long | |
Dim i As Long | |
Const COUNT_TARGET_COLUMN As Integer = 2 | |
Const dataPartRow As Long = 3 | |
row = Cells(Rows.count, COUNT_TARGET_COLUMN).End(xlUp).row | |
Application.ScreenUpdating = False | |
For i = row To dataPartRow Step -1 | |
' 表を末端から走査して行いたい処理を記述 | |
Next i | |
Application.ScreenUpdating = True | |
End Sub |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment