Public Function strRenketu(ByVal 連結文字 As String, ByVal 選択範囲 As Range, Optional ByVal 空白を連結する As Boolean = False) As String
     Dim i As Long
     Dim strReturn As String
     Dim flgFirst As Boolean
     Dim data As Range
     flgFirst = True
     For Each data In 選択範囲  'For Each でループ処理
        If 空白を連結する = False Then
            If data.Cells.Value <> "" Then
                If flgFirst = True Then
                    flgFirst = False
                    strReturn = data.Cells.Value
                Else
                    strReturn = strReturn & 連結文字 & data.Cells.Value
                End If
            End If
         Else
             If flgFirst = True Then
                 flgFirst = False
                 strReturn = data.Cells.Value
             Else
                 strReturn = strReturn & 連結文字 & data.Cells.Value
             End If
         End If
     Next data
     strRenketu = strReturn
 End Function