Why Cannot Directly Set Wrap On Range Of Cells

I would like to simply reference this range of cells and change one formatting attribute.

VB: Sheets("flaggedSite report").Range(Cells(RowV, 2), Cells(RowV, 6)).WrapText = True

I get a runtime error 1004 with this???

VB:
With Sheets("FlaggedSite Report").Range(Cells(RowV + 1, 2), Cells(RowV + 1, 5))
'.Range(Cells(RowV, 2), Cells(RowV, 6)).WrapText = True
.WrapText = True
End With

This one runs but gives me unpredicted results. This one I think changes the format on my original sheet vs FlaggedSite Report.

VB:
With Worksheets("FlaggedSite Report")
With Range(Cells(RowV + 1, 2), Cells(RowV + 1, 5))
.WrapText = True
End With
End With

All I want to do is with as small a code as possible make a change to an inactive sheet of my choosing to the wrap format of a range of cells.