Select a single line even if there are merged cells with VBA
Closed
                                    
                        Jerry                    
                                    -
                            Aug 17, 2016 at 03:39 PM
                        
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Aug 25, 2016 at 11:39 AM
        TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Aug 25, 2016 at 11:39 AM
        Related:         
- Vba select merged cells
 - Vba select case like - Guide
 - Excel online vba - Guide
 - How to select at the rate in laptop - Guide
 - To create a network bridge you must select at least two lan ✓ - Network Forum
 - Cannot get my home pc to bridge connections - Windows Forum
 
1 response
                
        
                    TrowaD
    
        
                    Posts
            
                
            2921
                
                            Registration date
            Sunday September 12, 2010
                            Status
            Contributor
                            Last seen
            December 27, 2022
            
            
                    555
    
    
                    
Aug 25, 2016 at 11:39 AM
    Aug 25, 2016 at 11:39 AM
                        
                    Hi Jerry,
Merged cells don't work well with VBA. You will have to start your code by unmerging first then finish the code by merging the cells again.
Best regards,
Trowa
 
                
                
            Merged cells don't work well with VBA. You will have to start your code by unmerging first then finish the code by merging the cells again.
Best regards,
Trowa