Sub SetCellValue()
MsgBox "将当前单元格中" & vbCrLf _
& "前面的单元格值设为""我前面的单元格""" & vbCrLf _
& "后面的单元格值设为""我后面的单元格"""
If ActiveCell.Address <> "$A$1" Then ActiveCell.Previous.Value = "我前面的单元格"
If ActiveCell.Address <> "$IV$65536" Then ActiveCell.Next.Value = "我后面的单元格"
End Sub
Sub SetCellValue()
MsgBox "将当前单元格中" & vbCrLf _
& "前面的单元格值设为""我前面的单元格""" & vbCrLf _
& "后面的单元格值设为""我后面的单元格"""
If ActiveCell.Address <> "$A$1" Then ActiveCell.Previous.Value = "我前面的单元格"
If ActiveCell.Address <> "$IV$65536" Then ActiveCell.Next.Value = "我后面的单元格"
End Sub