Re: Code help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks Don

"Don Guillett" wrote:

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


.

Relevant Pages

  • Re: Auto Paste Values
    ... Microsoft MVP Excel ... "Don Guillett" wrote: ... > macro I had in mind. ... >> Dim VBComps As VBIDE.VBComponents ...
    (microsoft.public.excel.programming)
  • Re: Excel 2003 - Macro for Deleting Rows
    ... Microsoft MVP Excel ... "Solon" wrote in message ... "Don Guillett" wrote in message ... I don't know which version he's working with, but my macro experience is largely with Sendkeys and recording some actions then reviewing the generated code along with some information sources..... ...
    (microsoft.public.excel.programming)
  • Re: Macro??
    ... found in the macro. ... "Connie Martin" wrote: ... "Don Guillett" wrote: ... Microsoft MVP Excel ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Macro??
    ... I changed mc to a everywhere mc shows up in the macro. ... "Don Guillett" wrote: ... Private Sub Workbook_Open ... Microsoft MVP Excel ...
    (microsoft.public.excel.worksheet.functions)
  • Re: hidden worksheet
    ... Microsoft MVP Excel ... "Don Guillett" wrote: ... > For Each anySheet In Worksheets ... > into hidden state and run the MakeJustHiddenVeryHidden macro. ...
    (microsoft.public.excel.misc)