That's 100% thanks Ron, just a further question if one had to look for a
row with a "Heading" in it e.g. "BP', it's location could be in any row
and then go to the last cell in the row, ignoring any blanks and put in
the total as per your script, how would the script change ?

Thanks very much for the help.

best regards,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***