Yeah, I have been trying it that way too. But still, only column A gets
used. The only way I have successfully added to column B is by:
With wksCopyFrom
Set rngToSearch = .Range(.Range("A3"), .Cells(Rows.Count,
"A").End(xlUp))
End With
wksCopyTo.Cells.ClearContents
Set rngPaste = wksCopyTo.Range("B2")
And if I created 7 total macros (near-carbon copies, but for columns
A-F), each one overwrites the other.
--
Justin810
------------------------------------------------------------------------
Justin810's Profile:
http://www.excelforum.com/member.php...o&userid=36415
View this thread:
http://www.excelforum.com/showthread...hreadid=558511