other
murata vba select cells after autofilter
Sub Macro4()
Dim R As Range
Range("A1").AutoFilter 1, "ç”°ä¸"
With Range("A1").CurrentRegion.Offset(1, 0)
'å„è¡Œ in 表示ã•ã‚Œã¦ã„ã‚‹å…¨ã¦ã®è¡Œ
For Each R In .Resize(.Rows.Count - 1).SpecialCells(xlCellTypeVisible).Rows
Debug.Print R.Address
'表示ã•ã‚Œã¦ã„ã‚‹è¡ŒãŒåŸºæº–ã¨ãªã‚‹
If R.Cells(1, 3) > 300 Then
MsgBox R.Cells(1, 2)
End If
Next R
End With
End Sub
Was this helpful?
Similar Posts