macro to add cell values

[tryer]

I've been going round in circles trying to write this simple piece of code (unsuccesfully)

I have a number of rows (say 1 to 100) and columns (say 1 to 20) with data in or possibly empty. What I want to do is add the contents of each cell in a row together (seperated with a comma) and place the result in cell 21 of each row

Thanks in advance.

[antoka05]

Try wih this code:

Please Login or Register  to view this content.

Regards,
Antonio

[Leith Ross]

Hello Tryer,

When you say "add the cell contents separated by commas", do you mean each cell has multiple values separated by commas?

Sincerely,
Leith Ross

[tryer]

Thanks Antonio, That worked exactly as I wanted -- Brilliant