Sub test7()
Dim v_ip1 As Long
Dim v_ip2 As Long
Dim v_ip3 As Long
Dim v_ip4 As Long
Dim v_subnet As Long
Dim str_temp1_ip1 As String
Dim str_temp1_ip2 As String
Dim str_temp1_ip3 As String
Dim str_temp1_ip4 As String
Dim len_str_temp1_ip1 As Long
Dim len_str_temp1_ip2 As Long
Dim len_str_temp1_ip3 As Long
Dim len_str_temp1_ip4 As Long
Dim str_ip32_temp_Netadd As String
str1 = Cells(4, 3).Value
str_temp1 = Split(str1, "/")
v_subnet = Val(str_temp1(1))
str_temp2 = Split(str_temp1(0), ".")
v_ip1 = Val(str_temp2(0))
v_ip2 = Val(str_temp2(1))
v_ip3 = Val(str_temp2(2))
v_ip4 = Val(str_temp2(3))
v_2_ip1 = f_2進数へ変換(v_ip1)
v_2_ip2 = f_2進数へ変換(v_ip2)
v_2_ip3 = f_2進数へ変換(v_ip3)
v_2_ip4 = f_2進数へ変換(v_ip4)
str_temp1_ip1 = LTrim - (Str(v_2_ip1))
str_temp1_ip2 = LTrim(Str(v_2_ip2))
str_temp1_ip3 = LTrim(Str(v_2_ip3))
str_temp1_ip4 = LTrim(Str(v_2_ip4))
len_str_temp1_ip1 = Len(str_temp1_ip1)
len_str_temp1_ip2 = Len(str_temp1_ip2)
len_str_temp1_ip3 = Len(str_temp1_ip3)
len_str_temp1_ip4 = Len(str_temp1_ip4)
Call f8桁へ変換(str_temp1_ip1, len_str_temp1_ip1)
Call f8桁へ変換(str_temp1_ip2, len_str_temp1_ip2)
Call f8桁へ変換(str_temp1_ip3, len_str_temp1_ip3)
Call f8桁へ変換(str_temp1_ip4, len_str_temp1_ip4)
str_ip32 = str_temp1_ip1 & str_temp1_ip2 & str_temp1_ip3 & str_temp1_ip4
str_ip32_temp_Netadd = Left(str_ip32, v_subnet)
str_ip32_Netadd = f8桁埋め(str_ip32_temp_Netadd, v_subnet)
Cells(7, 3).Value = str_ip32_temp_Netadd
Cells(8, 3).Value = Len(str_ip32_temp_Netadd)
End Sub
'10→2信変換-----------------------------------------------
Function f_2進数へ変換(Number As Long) As String
Dim myYard As Long
Dim myNumber As Long
Dim myExpo As Long
myNumber = Number
While 2 ^ myYard <= myNumber
myYard = myYard + 1
Wend
For myExpo = myYard - 1 To 0 Step -1
If myNumber >= 2 ^ myExpo Then
f_2進数へ変換 = f_2進数へ変換 & "1"
myNumber = myNumber - 2 ^ myExpo
Else
f_2進数へ変換 = f_2進数へ変換 & "0"
End If
Next
End Function
'-------------------------------------
Function f8桁へ変換(strip As String, lenip As Long)
Select Case lenip
Case 7
strip = "0" & strip
Case 6
strip = "00" & strip
Case 5
strip = "000" & strip
Case 4
strip = "0000" & strip
Case 3
strip = "00000" & strip
Case 2
strip = "000000" & strip
Case 1
strip = "0000000" & strip
End Select
End Function
Function f8桁埋め(strip As String, lenip As Long)
i = 0
While (32 - lenip) - i > 0
strip = strip & "0"
i = i + 1
Wend
End Function