union range
Union(Target.Offset(0, -11), Target.Offset(0, 8), _
Target.Offset(0, 7), Target.Offset(0, 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
...
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.
|