I'm trying to post data to another location in the same sheet using the Offset function but I keep getting "Runtime error 9, subscript out of range". The line that throws the error is the one that starts "Application.Worksheets . . .".
Set rng = Range("J17:AA17")
For Each myCell In rng...