VBA underscore trouble
Solved/Closed
        Related:         
- Vba range
 - Error 1004 vba - Best answers
 - Excelguru - Best answers
 - Vba case like - Guide
 - Excel online vba - Guide
 - Vba timer - Guide
 - Vba color index - Guide
 - Vba excel mac - Guide
 
4 responses
                
        
                    Excelguru
    
        
                    Posts
            
                
            261
                
                            Registration date
            Saturday April 11, 2009
                            Status
            Member
                            Last seen
            June 21, 2011
            
            
                    307
    
    
                    
Jul 20, 2009 at 01:17 AM
    Jul 20, 2009 at 01:17 AM
                        
                    Hello Trowa
You have to close the active string and use & to club the two strings as given below
 
Sub Mergeing()
ActiveSheet.Range("a1:a3," & _
"b1: b3 ").Merge
End Sub
            You have to close the active string and use & to club the two strings as given below
Sub Mergeing()
ActiveSheet.Range("a1:a3," & _
"b1: b3 ").Merge
End Sub
                        
                    Thanks Excelguru,
Your code works but mine not. It seems I've created a string longer than 912 characters (error 1004).
Got any tips to work around this issue or maybe a tool to count the characters?
Thanks in advance,
Trowa
            Your code works but mine not. It seems I've created a string longer than 912 characters (error 1004).
Got any tips to work around this issue or maybe a tool to count the characters?
Thanks in advance,
Trowa
                
        
                    Excelguru
    
        
                    Posts
            
                
            261
                
                            Registration date
            Saturday April 11, 2009
                            Status
            Member
                            Last seen
            June 21, 2011
            
            
                    307
    
    
                    
Jul 20, 2009 at 11:22 PM
    Jul 20, 2009 at 11:22 PM
                        
                    Info from Micorsoft
https://support.microsoft.com/en-us/help/818808
            https://support.microsoft.com/en-us/help/818808