Combine values across columns into 1 text string

I have been having difficulty being able to combine the text in the applicable row from columns 8 to lastRow into one text string that will then be written to a file. The line I am stuck on is F$I also want to round the values in those cells to be 3 digits long. Please help me figure out my error and clean this up. Thank you.

Please Login or Register  to view this content.

Your combine function appears to return a two dimensional array. Therefore it cannot simply be concatenated into a string.

It looks like the second dimension has a size of 1.

The line I am stuck on is F$.

What's the problem here?

I also want to round the values in those cells to be 3 digits long.

You might try

Please Login or Register  to view this content.

and make sure the format is set in the cell, else you'll have to iterate the whole range and use the VBA format function.