vba 几个单元格的数据拼凑成一个答:Sub 组合()Dim JGArr(), TopRow, EndRow As VariantDim Rng As Range, N, EndCol As LongTopRow = Application.InputBox("输入首行号:", "首行号输入", 2, Type:=1)EndRow = Application.InputBox("输入尾行号:", "尾行号输入", 2, Type:=1)If TopRow = "False" Or EndRow = ...
如何用VBA编程实现两个单元格内容的合并,例如在A1里的内容是ABC,在B1...答:dim a,b a=replace(cells(1,1)," ","")b=replace(cells(1,2)," ","")cells(1,3)=a&b 即可