castak
03-05-2019, 01:42 AM
Hi,
I've got a problem in my Worksheet_SelectionChange event.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim SelectCel As Range
Dim SelectCelOffset As Range
With Sheets(1)
Set SelectCel = .Cells(Target.Row, 2)
SelectCelOffset = SelectCel.Offset(0, 2).Select
MsgBox SelectCelOffset.Address
End With
End Sub
I'm trying to activate the cells that is 2 columns after the one I select.
But I've got an error message 91 on this line :
SelectCelOffset = SelectCel.Offset(0, 2).Select
Can someone help me ?
I've got a problem in my Worksheet_SelectionChange event.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim SelectCel As Range
Dim SelectCelOffset As Range
With Sheets(1)
Set SelectCel = .Cells(Target.Row, 2)
SelectCelOffset = SelectCel.Offset(0, 2).Select
MsgBox SelectCelOffset.Address
End With
End Sub
I'm trying to activate the cells that is 2 columns after the one I select.
But I've got an error message 91 on this line :
SelectCelOffset = SelectCel.Offset(0, 2).Select
Can someone help me ?