View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AD108[_2_] AD108[_2_] is offline
external usenet poster
 
Posts: 9
Default Simple problem, must be too early...

The Select method is failing below, not sure what I am doing wrong. My goal
is to synchronize the selection across several sheets. I am using
"SelectionChange" event to fire little code below.

Thanks in advance for help.

Public rwSelect as integer

Sub Sync_Sheets()
Dim rng As Range
rwSelect = Selection.Row
Set rng = Sheets(2).Range("C" & rwSelect)
rng.Select
Sheets(14).Activate

End Sub