I am using the following code to find "mySite1" which is always in column A.

Cells.Find(What:=mySite1, After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate

Once "mySite1" is found, I need the code to highlight from the selected,
found cell, including that cell, over to the right for a total of 22 cells.
So for example, if my code finds "mySite1" at A5, I need the code to
highlight A5 to V5. If my code finds "mySite1" at A7, I need the code to
highlight A7 to V7, 22 cells total.
Because "mySite1" can be on a different row from one report to another, I
can not specify the actual cells, ie A5:V5.

I tried using this code after "mySite1" is found but it does not work if any
cells between column A & V are blank even if I use the code multiple times.

Range(Selection, Selection.End(xlToRight)).Select

How can I write code to select a number of cells without specifying cells
like A5:V5?
I need to find "mySite1" then highlight from the found cell in column A to
column V same row # as the found cell.

Any help is appreciated.