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
- Based on the cell values in cells b77 - Excel Forum
- Excel arrow keys not moving cells - Guide
- An example of a cell is a blank cell ✓ - Programming Forum
- Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array ✓ - 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