excel vba合并字符串
答案:2 悬赏:60 手机版
解决时间 2021-03-31 06:34
- 提问者网友:喧嚣尘世
- 2021-03-30 12:00
excel vba合并字符串
最佳答案
- 五星知识达人网友:风格不统一
- 2021-03-30 12:36
Sub a()
Dim rg As Range, str As String
str = "A"
For Each rg In ActiveSheet.Range("b5:e12")
If rg <> "" Then str = str & Right(rg, 1)
Next
ActiveSheet.Range("b1") = str
End Sub
Dim rg As Range, str As String
str = "A"
For Each rg In ActiveSheet.Range("b5:e12")
If rg <> "" Then str = str & Right(rg, 1)
Next
ActiveSheet.Range("b1") = str
End Sub
全部回答
- 1楼网友:woshuo
- 2021-03-30 12:55
sub a()
dim str as string
str="a"
arr=activesheet.usedrange
for each cl in arr
if cl<>"" then str=str & left(cl,1)
next
msgbox str
end sub追问修改为固定范围(B5:E12)
结果在B1追答sub a()
dim str as string
str="a"
arr=range("B5:E12")
for each cl in arr
if cl<>"" then str=str & left(cl,1)
next
[b1]=str
end sub
dim str as string
str="a"
arr=activesheet.usedrange
for each cl in arr
if cl<>"" then str=str & left(cl,1)
next
msgbox str
end sub追问修改为固定范围(B5:E12)
结果在B1追答sub a()
dim str as string
str="a"
arr=range("B5:E12")
for each cl in arr
if cl<>"" then str=str & left(cl,1)
next
[b1]=str
end sub
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
点此我要举报以上问答信息
大家都在看
推荐资讯