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
- Vb net round - Guide
- Vb net find last row in excel sheet - Guide
- Vb net add sheet to excel workbook - Guide
- Based on the values in cells b77 b81 c77 - Excel Forum
- Based on the values in cells b77 b81 what function can automatically return the value in cell c77 ✓ - Excel Forum
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
