Code help
wks1.Cells(iRow, 1).resize(1,15).Copy Destination _
Is another way.
Anthony wrote:
Hi
I have this bit of code that is part of a macro to search for and copy paste
data when a match is found.
wks1.Cells(iRow, 1).EntireRow.Copy Destination _
I don't want the ENTIRE ROW to be copied just the range A:O
can anybody adapt the code for me please to carry this out
thanks
--
Dave Peterson
|