VB returning cells of fount results
Closed
wil
-
Sep 14, 2009 at 10:08 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Sep 16, 2009 at 11:14 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Sep 16, 2009 at 11:14 PM
Related:
- VB returning cells of fount results
- If two cells match return value from third ✓ - Excel Forum
- Excel arrow keys not moving cells - Guide
- Vb select case - Guide
- Based on the values in cells b77 ✓ - Excel Forum
- Excel macro to create new sheet based on value in cells - Guide
1 response
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Sep 16, 2009 at 11:14 PM
Sep 16, 2009 at 11:14 PM
Hello
I think you need to change this code
Range("a40:AD50", Cells(i, 1)) = FoundCell.EntireRow.Value
From your query" return the whole row back to a different range" you want to copy an entire row
for this rows(number1).copy
rows(number2).select
activesheet.paste
will copy the entire row
I think you need to change this code
Range("a40:AD50", Cells(i, 1)) = FoundCell.EntireRow.Value
From your query" return the whole row back to a different range" you want to copy an entire row
for this rows(number1).copy
rows(number2).select
activesheet.paste
will copy the entire row