我是这么声明的
Public arr As Variant
在一个过程里赋值
Sub test()
arr = {"饮料","2101","2501"; "食品","2102","2601" ; "蔬菜","2103","2701"}
End Sub
然后,就 直报错,哪里不对吗?
我想让这个二维数组成这个样子(三行两列):
"饮料" "2101","2501"
"食品" "2102","2601"
"蔬菜" "2103","2701"
应该怎么声明和赋值啊?
字符串里的引号也要保留.
VBAä¸å¨æå®ä¹ä¸ä¸ªäºç»´æ°ç»ï¼æ¡ä¾ä»£ç å¦ä¸ï¼
//å®ä¹å¨ææ°ç»tt好像不行啊.
追答如何报错的?最好贴个图。我专门试了一下,是对的。数组赋值,两端加方括号。
下图为测试结果:
我想要的结果是这样的,都带有引号,是个三行二列的数组.
arr(1)
arr(1,1)"饮料"
arr(1,2)"2101","2501"
arr(2)
arr(2,1)"食品"
arr(2,2)"2102","2601"
arr(3)
arr(3,1)"蔬菜"
arr(3,2)"2103","2701"
亲,看一下是这个意思不:
arr = [{"""饮料""", """2101"", ""2501""";"""食品""", """2102"", ""2601"""; """蔬菜""", """2103"", ""2701"""}]