VBA underscore trouble
Solved/Closed
Related:
- Vba range
- Error 1004 vba - Best answers
- Excelguru - Best answers
- Vba case like - Guide
- Number to words in excel formula without vba - Guide
- Vba check if value is in array - Guide
- Vba color index - Guide
- How to open vba in 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