retain Selection
Hi Dr Fear,
Stripping the code to that which is
essential, try:
'==========
Public Sub Tester()
Dim Rng As Range
Dim rCell As Range
Set Rng = Selection
Set rCell = ActiveCell
' \\ Your code
Application.Goto Reference:=Rng
rCell.Activate
End Sub
'<==========
---
Regards.
Norman
|