Combine known column and row based on cell contents VBA
Combine known column and row based on cell contents VBA
(OP)
Hi All.
This seems like it should be easy and I know I've done something similar in the past.
Sub ScrollToName()
Dim RN As Integer
RN = Range("P5").Value
ActiveWindow.ScrollRow = RN
Range("E + RN").Select
End Sub
It scrolls to the top perfectly but I can't seem to get it to select the cell I want it to.
Obviously I'm missing something.
Thanks, Doug
This seems like it should be easy and I know I've done something similar in the past.
Sub ScrollToName()
Dim RN As Integer
RN = Range("P5").Value
ActiveWindow.ScrollRow = RN
Range("E + RN").Select
End Sub
It scrolls to the top perfectly but I can't seem to get it to select the cell I want it to.
Obviously I'm missing something.
Thanks, Doug





RE: Combine known column and row based on cell contents VBA
Range("E" & RN).Select
Works perfect.
RE: Combine known column and row based on cell contents VBA
CODE
Skip,
Just traded in my OLD subtlety...
for a NUance!