VBA to concatenate a string, to a cell value in a range, to another string.

[Sacharny]

Hello,

I have a column filled with image file names (exp: QU12345 ) on a "Source" sheet of the workbook. On sheet "Results" of this workbook I have to fill a column down to the end where each row of is the result of concatenating www.acme.com\, the respective row with the image name, and - 1.jpg, so that the result will be for example: www.acme.com\QU12345- 1.jpg



This is what I did, but does not work:

Please Login or Register  to view this content.

Could anybody help me please? I tried so many other versions, but nothing I do works. I don't know how to make loops but read many times loops are slow. My files could be 400 rows long, and there 3 other URL addresses I have to concatenate that way in the same workbook.

I also posted it at http://www.ozgrid.com/forum/showthread.php?t=179664

Thank you so much for any help.

(Thanks Mordred, sory about that )

[Mordred]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

[JBeaucaire]

Maybe:

Please Login or Register  to view this content.

[Sacharny]

It works!

Wow! Why is that? I would love to know.

Thank you so much!

[JBeaucaire]

In the end you were trying to create a "string" like a formula from pieces of text. The only thing you missed was that you were ACTUALLY creating a string, and all pieces of string require quotes around them. IF you look in the resulting cells, you'll see the formula you almost created, and the one I did.

[Sacharny]

Thank you. You are super!