質問者が納得いろいろな方法が考えられると思いますが、まあひとつの例として
Public Function Sample(rngBranches As Range, rngBranchList As Range)
Dim intTerms As Variant, strBranches As Variant
Dim R As Range
Dim strBefore As String, intC As Integer
Dim X As Integer, Y As Integer
X = rngBranches...
6171日前view33