I have two questions about cacatenation in excel:

1) what would be the VB code for inserting a column and putting in it a
cacatenation of all the columns to the right when the number of columns
is changing from worksheet to worksheet. In some worksheets, the number
of columns to cacatenate may be four, in others 5, etc.

2) how could cacactentation be done for only those columns with specific
headings in the first row. For example, cacatenate only those columns
with headings "company" and "country". Some code on this would be
appreciated.

Thanks.

Matthew Kramer

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!