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.