Select rows based on selected cells

[dyscea]

I search and highlight for a very unique string ie. "Header", find all, highlight all.

With the cells I needed selected, I would like to select the row as well. I tried Shift+Space, but it only selected the row of the last cell selected.

My end goal is to then highlight the rows as a visual aid.

I've seen solutions using filters, but that isn't as clean as what I had described above. And I've seen it done! Many moons ago. It was awesome for what I needed to do. This was when I was younger and before Drive to save it. Clearly, I haven't needed it since, but now I do.

Thank you in advance!

 

[ZMyrrh]

The easiest way without using code would be to click the Row then press "Shift + Space" then while holding Ctrl, Click the next row. Again press "Shift + Space". Repeat this for every row you want to highlight. If you want a way to do this with code using "Ctrl + Shift + H" then go to Developer, Visual Basic, In the VBAProject area find "Personal.XLSB" press that. Then press "Insert", "Module", then click the gray area. Then Paste this:

Public Sub highLightRowShortcut()

Application.OnKey "+^H", "HighLightRow"

End Sub




Public Sub HighLightRow()

Selection.EntireRow.Activate

End Sub

Click On highLightRowShortcut then Press "F5" or the "Green Play Button" towards the top. After that you should be able to select the headers while holding "CTRL" then Press "Ctrl + Shift + H" they should highlight the rows from now on when you do this.

Let me know how this goes!

 

[dyscea]

Chef's kiss. Thank you! Sorry for the late reply. I wanted another Monday data to try it.

Solved!!