You are welcome. Glad to be of help.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

Cheers for this, works a treat. I see where I was going wrong. My
thinking was that I had to address the whole matrix, not just the
values as is the case.


Many thanks, all very clear how this works. Easy when you know how.


It was really bugging me but I was addressing the whole matrix, titles
and values.

Many thanks again i can now do the calcs i wanted, will save a lot of
time too.

Regards
Bob :)


--
spikk
------------------------------------------------------------------------
spikk's Profile: http://www.excelforum.com/member.php...o&userid=24932
View this thread: http://www.excelforum.com/showthread...hreadid=384691