Getting Rid Of Blank Cells

F

foolio

I know there is a way to git rid of excess cells....something like cntr
s to save then cntrl end and then cntrl s again...

What is the could for this in vba ??

Note that I mean how do i get rid of the excess cells... i do not wan
to and can not save this file while getting rid of blank cells
 
D

Dave Peterson

Debra Dalgleish has some code at:
http://www.contextures.com/xlfaqApp.html#Unused

But the bad news is that with some versions of excel (xl97 mostly), you
sometimes had to do a save. In fact, sometimes you had to close it and reopen
it for it to take effect (IIRC).

But for the most part, that code works ok for me.
 
Top