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