The code for the range of each sheet is really useful and I'll be using
it.Thanks. What I was really after is how much disk space each sheet in
a workbook is using. I've got a workbook with ten sheets (some with
charts) and it weighs in at over 5 mb and I can't figure out where all
the disk space is being used. I need to thin it down so I can send it
out over the network and 5 mb is too big.


--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=514362