-
How to set Range based off Target Range?
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.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules