Cut, concatenate and paste into blank cell on separate sheet

[T86157]

I want to make a blank "form" where the user will use Sheet1 to enter in some data in two or more cells. For example, A1, A2 and A3. I would like for a VBA macro to cut this data from Sheet1, concatenate it together as a string and paste it into Sheet2 in the same column (Column A for example) with the next empty cell.

Please Login or Register  to view this content.

I think the above code is a starting point but I keep getting an error from using this code. I pulled this from someone else who had a similar goal a while back... Not sure if it makes a difference but I use Excel 2010.

[mangesh.mehendale]

Hii problem is you are using both cut and paste special option...

Either

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

and finally

Please Login or Register  to view this content.

[:) Sixthsense :)]

Please Login or Register  to view this content.

[T86157]

H mangesh.mehendale and sixthsense, thank you for the timely response! This got me further to what I want to do. If the cells I want to cut from Sheet1 are no adjacent to each other (A1:A3), how would this be written? For example instead of cutting Range("A1:A3") I would like to cut cells A1, C8, F3. I tried Range("A1, C8, F3") because I thought it would follow excel convention with cell list referencing.

[mangesh.mehendale]

hii try this

Please Login or Register  to view this content.

[:) Sixthsense :)]

Please Login or Register  to view this content.