Is there a way of adding cells by picking up on their cell format? I am
copying info from sheet one which has a subtotal at the end. There will be
more than one set of subtotals copied over and I need to be able the
calculate the total by picking up on the cell format.

You can see something similar to this problem on my download page. In
this case its sorting by colour (a type of format)


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=540162