Breaking out Comma Delimited Fields - VBA Error - "Subscript out of Range"

**sev979** · 02-13-2014, 09:49 AM

ExpenseReportv1.xlsmI'm getting an error with the following Macro. It's designed to break out comma delimited fields (fields F:R) into separate rows on a second sheet (moving from "Raw Sharepoint Data" to "Format - Level 1"). It works for the first row, but when it moves down to the second row, the macro fails and I get the error "Runtime error '9': Subscript Out of Range". When I open the debugger, it looks like it errors out on the line "rf = arrf(0)" (in red below). The full range of the data is columns A:R, but I've tried extending the range in the macro out as far as A:Z, and I still get the error. Any help would be appreciated.

Please Login or Register  to view this content.

**Norie** · 02-13-2014, 09:55 AM

I think the problem might be that rf is an empty string/cell.

By the way, you've got a lot of variables in that code, pretty sure it could be tidied up a bit.

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

PS Can you add code tags?

**sev979** · 02-13-2014, 10:09 AM

Yeah, I will definitely be cleaning up the variables, but as it stands I might have to change which columns I use, and this makes it easier for me to visualize until it's finalized.

I've attached a file with some sample date below, and added the tags to my above post. I appreciate the help.