Thread
:
Code help
View Single Post
#
5
Posted to microsoft.public.excel.programming
Dave Peterson
external usenet poster
Posts: 35,218
Code help
Just qualifying the ranges:
wks1.range(wks1.Cells(iRow, "a"),wks1.cells(irow,"o")).Copy Destination _
Don Guillett wrote:
wks1.range(Cells(iRow, "a"),cells(irow,"o")).Copy Destination _
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Anthony" wrote in message
...
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
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson