View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
shelfish shelfish is offline
external usenet poster
 
Posts: 39
Default How to resize worksheet

Could someone point me in the right direction for how to resize a
worksheet. I have a macro that deletes a lot of rows. After is
finishes, I want to hit "ctrl+A" but it grabs the original number of
uses cells. Make Sense?

I know ASAP utilities already has something like this but I want to
work this function into the middle of a macro.

Thanks in advance,
Shelton