Advertisement
Guest User

Untitled

a guest
Apr 30th, 2018
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.     Do While index <= ColumnNum
  2.        
  3.         '- カラムスキップ処理を記述 ----------------------------------'
  4.        'スキップ列でなかった場合
  5.        If skipFlag = 0 Or Cells(11, index) <> "○" Then
  6.             text = text & Cells(row - 1, index).value
  7.             index = index + 1
  8.         If text Is Nothing Then
  9.             text = text.Clear
  10.             If index <= ColumnNum Then
  11.                 text = text & ","
  12.             End If
  13.            
  14.         'スキップ列の場合
  15.        Else
  16.             index = index + 1
  17.         End If
  18.         '-------------------------------------------------------------'
  19.  
  20.     Loop
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement