Macro to combine multiple cell formulas

**ameerhamzauk** · 06-05-2012, 01:24 PM

Hi,

I am new to the VBA world and at lost

I need help with the following:

I would like to have the freedom of selecting multiple cells, and have the LAST cell in this multicell selection combine the formulas contained in each of the cells selected (feel free to ignore what is already contained in the LAST cell). Formulas would need to be seperated by the '+' sign

Please kindly advise. Much appreciated.

Ameer

**tlafferty** · 06-05-2012, 01:44 PM

Try this:

Please Login or Register  to view this content.

**ameerhamzauk** · 06-05-2012, 02:36 PM

Many thanks for the swift response

Quick follow up: wouldn't 'C' need be declared as object or range or something becaaue currently I am getting an invalid property/argument error.

Thanks!

**tlafferty** · 06-05-2012, 03:20 PM

C is just shorthand for a variable which is dimensioned when the for next loop starts. It could as easily be cll or some other text value. Be sure that your last selection is an empty cell, and that the other cells in your selection contain a formula, then try running it again. I'm not getting an error. See attached.