Try to make more clear if I can The Target cell isin Column (L)or 12 -11
being (A)
-8 being (D) -7 being(E) -5 being(G) I got idea that any cell to left of
target was a minus (-) (L)or 12 would make (K) (0,-1)(J)(0,-2) target is (0)
in count ?
If I follow your responce then I must list each cell in offset group correct?
All of you that respond have a lot to get an understanding of what another
is doing.
Thanks
"JE McGimpsey" wrote:

But what does

cells -11,8,7,5 and the target cell

mean to you? It doesn't make sense as VBA.

Is it 5 different cells: e.g.,

(1) target
(2) target.Offset(-11, 0) or target.Offset(0, -11)
(3) target.Offset(8, 0) or target.Offset(0, 8)
(4) target.Offset(7, 0) or target.Offset(0, 7)
(5) target.Offset(5, 0) or target.Offset(0, 5)


Or is it three cells: e.g., target, target.Offset(-11, 8) and
target.Offset(7, 5)?


Or are you referring to some variant of the worksheet function: e.g.,

target and target.Offset(-11, 8).Resize(7, 5)

or something else entirely?

In article ,
Curt wrote:

What I want to do is to copy cells -11,8,7,5 and the target cell.