Moderator: RDNZL




sAddressSplit = Split(sAddress, "|" "/")
sA1 = Val(sAddressSplit[6]) & Val(sAddressSplit[7])
sA2 = Val(sAddressSplit[8])
But should be:
sAddressSplit = Split(sAddress, "|" "/")
sA1 = Val(sAddressSplit[0]) & Val(sAddressSplit[1])
sA2 = Val(sAddressSplit[2])
DIM sAddresses AS String[]
DIM sGroup AS String
sAddresses = Split(sAddress, "|")
FOR EACH sGroup IN sAddresses
sAddressSplit = Split(sGroup, "/")
sA1 = Val(sAddressSplit[0]) & Val(sAddressSplit[1])
sA2 = Val(sAddressSplit[2])
' do your thing with it and go to the next
NEXT








Users browsing this forum: Google [Bot] and 1 guest