請問如何改寫以下VBA(如何不使用中括號)
請問有無簡潔的寫法(一列)而不用中括號
arr1 = [transpose(if(A1:A20="","",""))]
arr2 = [transpose(transpose(if(A1:K5="","","")))]
sa = [index(int((row(1:125)-1)/25)+1 & int(mod((row(1:125)-1),25)/5)+1 & mod(row(1:125)-1,5)+1,)]
a_sn = [if(row(1:5)<transpose(row(1:5)),mid("ZFHKN",row(1:5),1) & transpose(mid("ZFHKN",row(1:5),1)),"")]
b_sn = [row(A1:D10)^column(a1:D10)]
已邀請的邦友 {{ invite_list.length }}/5
iThome鐵人賽
看影片追技術