'查找活动单元格右边第一个空白单元格
Sub aa()
If ActiveCell.Column <> Cells.Columns.Count Then
If ActiveCell.Offset(0, 1) <> "" Then
MsgBox ActiveCell.End(xlToRight).Offset(0, 1).Address
Else
MsgBox ActiveCell.Offset(0, 1).Address
End If
Else
MsgBox "已到最右边"
End If
End Sub