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