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.