it's probably trivial, but my brain is boiling by now..
i am trying to offset the range to the right using the following -
LastInsp = WorksheetFunction.Match(1, Range("EB" & r & ":EY" & r).Offset(0, c), 0)
where 'c' changes from 0 to n as i go through the table.
my problem is that it ADDS n columns to the range, and i'd like it to SHIFT the range n columns to the right.
???
l
i am trying to offset the range to the right using the following -
LastInsp = WorksheetFunction.Match(1, Range("EB" & r & ":EY" & r).Offset(0, c), 0)
where 'c' changes from 0 to n as i go through the table.
my problem is that it ADDS n columns to the range, and i'd like it to SHIFT the range n columns to the right.
???
l