Re: Code help

From: "Don Guillett" <dguillett1@xxxxxxxxxxxxx>
Date: Wed, 23 Jul 2008 10:42:56 -0500

wks1.range(Cells(iRow, "a"),cells(irow,"o")).Copy Destination _

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@xxxxxxxxxxxxx
"Anthony" <Anthony@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:FB4F6F4E-B69F-407E-BEDD-A9441FB4F5F4@xxxxxxxxxxxxxxxx

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

Follow-Ups:
- Re: Code help
  - From: Dave Peterson
- Re: Code help
  - From: Anthony

Prev by Date: Re: Detect UPPERCASE in cell value?
Next by Date: Re: Countif and
Previous by thread: Trimming work*** name from an imported data source
Next by thread: Re: Code help
Index(es):
- Date
- Thread