Maybe

Union(Range(Target.Offset(0,-11,8,7,5)),Target).Copy _
Destination:=rngPaste


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Curt" wrote in message
...
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