vba的数组长度太长怎么办

如题所述

推荐答案 2017-01-16

ä½¿ç¨åéç¬¦
Sub æé®6_åå»()
Dim a As String
a = Array("äº§å001", "äº§å002", "äº§å003", "äº§å004", "äº§å005", "äº§å006", "äº§å007", "äº§å008", "äº§å009", "äº§å010", "äº§å011", "äº§å012", "äº§å013", "äº§å014", "äº§å015", "äº§å016", "äº§å017", "äº§å018", "äº§å019", "äº§å020", "äº§å021", "äº§å022", "äº§å023", "äº§å024", "äº§å025", "äº§å026", "äº§å027", "äº§å028", "äº§å029", "äº§å030", "äº§å031", "äº§å032", "äº§å033", "äº§å034", "äº§å035", "äº§å036", "äº§å037", "äº§å038", "äº§å039", "äº§å040", "äº§å041", "äº§å042", "äº§å043", "äº§å044", "äº§å045", "äº§å046", "äº§å047", "äº§å048", "äº§å049", "äº§å050", "äº§å051", "äº§å052", "äº§å053", "äº§å054", "äº§å055", "äº§å056", "äº§å057", "äº§å058", "äº§å059", "äº§å060", "äº§å061", "äº§å062", "äº§å063", "äº§å064", "äº§å065", "äº§å066", "äº§å067", "äº§å068", "äº§å069", "äº§å070", "äº§å071", "äº§å072", "äº§å073", "äº§å074", "äº§å075", "äº§å076", "äº§å077", "äº§å078", "äº§å079", "äº§å080", "äº§å081", "äº§å082", "äº§å083", "äº§å084", "äº§å085", "äº§å086", "äº§å087", "äº§å088", "äº§å089", "äº§å090", "äº§å091", "äº§å092", _
"äº§å101", "äº§å102", "äº§å103", "äº§å104", "äº§å105", "äº§å106", "äº§å107", "äº§å108", "äº§å109", "äº§å110", "äº§å111", "äº§å112", "äº§å113", "äº§å114", "äº§å115", "äº§å116", "äº§å117", "äº§å118", "äº§å119", "äº§å120", "äº§å121", "äº§å122", "äº§å123", "äº§å124", "äº§å125", "äº§å126", "äº§å127", "äº§å128", "äº§å129", "äº§å130", "äº§å131", "äº§å132", "äº§å133", "äº§å134", "äº§å135", "äº§å136", "äº§å137", "äº§å138", "äº§å139", "äº§å140", "äº§å141", "äº§å142", "äº§å143", "äº§å144", "äº§å145", "äº§å146", "äº§å147", "äº§å148", "äº§å149", "äº§å150", "äº§å151", "äº§å152", "äº§å153", "äº§å154", "äº§å155", "äº§å156", "äº§å157", "äº§å158", "äº§å159", "äº§å160", "äº§å161", "äº§å162", "äº§å163", "äº§å164", "äº§å165", "äº§å166", "äº§å167", "äº§å168", "äº§å169", "äº§å170", "äº§å171", "äº§å172", "äº§å173", "äº§å174", "äº§å175", "äº§å176", "äº§å177", "äº§å178", "äº§å179", "äº§å180", "äº§å181", "äº§å182", "äº§å183", "äº§å184", "äº§å185", "äº§å186", "äº§å187", "äº§å188", "äº§å189", "äº§å190", "äº§å191", "äº§å192", "äº§å193" _
"äº§å198", "äº§å199", "äº§å200", "äº§å201", "äº§å202", "äº§å203", "äº§å204", "äº§å205", "äº§å206", "äº§å207", "äº§å208", "äº§å209", "äº§å210", "äº§å211", "äº§å212", "äº§å213", "äº§å214", "äº§å215", "äº§å216", "äº§å217", "äº§å218", "äº§å219", "äº§å220", "äº§å221", "äº§å222", "äº§å223", "äº§å224", "äº§å225", "äº§å226", "äº§å227", "äº§å228", "äº§å229")
End Sub

温馨提示：答案为网友推荐，仅供参考

当前网址：https://verywind.cn/ee/fevv377xryfxex27xe.html

其他回答

第1个回答 2017-01-16

例如某数组名称是a
计算它的长度就是 Ubound(a) + 1,Ubound()函数是用来获取数组中最大上限。例如某数组有5个元素,那么，通过个取得的最大上限就是4，因为vb中的数组是从0开始的，所以在取得这个最大上限之后还需要加上一个1.本回答被网友采纳

你可能感兴趣的内容

大家正在搜

vba获取数组长度的方法数组array的长度 vba 数组长度 vba不固定长度数组 vba 小数组赋值到大数组 vba不定长数组 vba数组作为参数数组vba vba获取数组大小

非常风气网www.verywind.cn

vba的数组长度太长怎么办

相关了解……

你可能感兴趣的内容