Thread: Code help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anthony Anthony is offline
external usenet poster
 
Posts: 275
Default Code help

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