Hi, I am trying to take two cells and concatenate them for an unspecified range (it could be 50 cells or it could be 500) using a VBA macro.  I would like to get FrontDimension & Cup combined in the F_demension as well as BackDimension & Cup into B_Dimension.  My sample data is below.  Thanks for all your help in advance!

FrontSize	FrontDimension	BackSize	BackDimension	Cup	F_Dimension	B_Dimension
22	13	22	13	A
32	18	28	18	B
35	16	28	14	A

Hi A_Shannon,

Based on your description, my understanding is you wonder to combined FrontDimension or BackDimension column with Cup column. And I test it in my own environment as shown in the following figure:

Please check if the results in column F and column G is your needed. If yes, you can use the formula: =B2&E2 to get the result.

If my understanding is incorrect, please be a bit more precise explain your requirement so that I can get more accurate solutions to this problem.

And you said you wondered to get the result by using a VBA macro, you could post your issue to MSDN forum for Excel:

http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Hope its helpful.

Regards,

George Zhao
TechNet Community Support

Yes that is the output I am looking for but I would like to use VBA to do it.

Thanks

Hi A_Shannon,

Im not good at using VBA macro, and I found you posted your issue to MSDN forum for Excel. I hope you can find the solution in that forum, good luck. J

Regards,

George Zhao
TechNet Community Support