如何鏈接CSVTypeColumn= CSVType01= "AL"？無論如何，它必須讓 if CSVTypeColumn.value= CSVType01Then CSVTypeColumn.value= "AL"?
'''''Module1
Public CSVType01 As String
CSVType01 = "AL"
'''''Module2
For CSVTypeColumnCount = 1 To 6
Dim CSVTypeColumn As String
CSVTypeColumn = "CSVType0" & CSVTypeColumnCount
Dim FindCSVType As Range
Set FindCSVType = .Range(CSVTypeColumn & 1).Column '<-- Wrong here!
uj5u.com熱心網友回復：
使用陣列：
Public CSVType(1 To 6) As String
CSVType(1) = "AL"
' etc
For CSVTypeColumnCount = 1 To 6
Dim CSVTypeColumn As String
CSVTypeColumn = CSVType(CSVTypeColumnCount)
uj5u.com熱心網友回復：
那行不通。當您感覺不需要在變數名中使用數字時，那您就錯了！
改用陣列。
Public CSVType(1 To 6) As String
CSVType(1) = "AL"
CSVTypeColumn = CSVType(CSVTypeColumnCount)
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/358953.html