| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Code help
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Code help
Thanks Don
"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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
| Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. | Excel Programming | |||
| Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
| How to assign same code inside Option button code space ?? | Excel Programming | |||
| Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming | |||
Linear Mode
