I have a range of cells that I need to export from 10,000 separate workbooks. Most of the workbooks will not have any value in this range, but some could have as many as 24 in this range. CONCATENATE in excel can almost get me what I need, but I want this in VBA script as part of a macro I already run to export from these files.

This is as close as I can get to what I need, but I don't want to return any commas if there isn't data:
=B11&","&B12&","&B13&","&B14&","&B15&","&B16&","&B17&","&B18&","&B19&","&B20&","&B21&","&B22&","&B23&","&B24&","&B25&","&B26&","&B27&","&B28&","&B29&","&B30&","&B31&","&B32&","&B33&","&B34

This returns ",,,,,,,,,,,,,,,,,,,,,,," when there are no values, or ",,,,,,RED,,,,,,BLUE,,,,0,,,0.9,,,," if there are values.

Also, this is in a cell in excel, and I want to do it in VBA as part of a macro (not in a cell). Please help!

Thank you!!!