Macro for concatenation

Hi Champs,

I have values in A1,B1,C1 and i need a macro to concatenate these in D1 as (valueof A1-valueof B1-valueof C1-00000-00000) .

Please note: I need the hyphen in between values and 00000 at last. I have attached the sample for the reference.


Thanks for the help in advance.

Why can not you use a simple formula?

Yes by formula it works. But i need a macro for this scenario.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

FWIW:

Please Login or Register  to view this content.

It works for formula but not for macros. Please help me in VBA syntax of this.

Thanks JOHN H. DAVIS. your code works fine. Thanks a lot.

The code works too. See the attached. You need to adjust your range, as I used current region- Have been very lazy with range.

Thanks AB33 for assissting and helping me out of this... cheers

I thought you want to loop through column A. Do you just have a single cell?

Hi AB33 your code too works fine. Thanks so much ....

Originally Posted by rajkumarmp

Thanks JOHN H. DAVIS. your code works fine. Thanks a lot.

You're welcome. BTW AB33's code works as well and does the entire column.