How to set Range based off Target Range?

[kend0g187]

I want to do something like this:

Private Sub Worksheet_Change(ByVal Target As Range)
* * *Dim affectedRange As Range
* * *affectedRange = Target + 6 columns
End Sub

Here's an example of what I mean by "+ 6 columns": If the target range was C4, then affectedRange should be C4:I4. If target was C4:E8 the affectedRange should be C4:L8.