The VBA Offset method only takes 2 arguments (see VBA Help), so it's
hard to see what you're trying to do here, or even how many cells you're
trying to copy...

Perhaps:

With Target
Union(.Offset(0, -11), .Offset(0, 7).Resize(1, 2), _
.Offset(0, 5), .Cells).Copy _
Destination:=rngPaste
End With

????


In article ,
Curt wrote:

have not used union before trying following not good HELP
Thanks

Union(Range(Target.Offset(0,-11,8,7,5))),target.offset(0,0).Copy _
Destination:=rngPaste
What I want to do is to copy cells -11,8,7,5 and the target cell. The target
cell is text all others are numeric. Target cell is the trigger for this.

Thanks Again