How to resize worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shelfish - 21 Nov 2007 03:06 GMT

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

Reply to this Message

Gord Dibben - 21 Nov 2007 03:25 GMT

CTRL + a will select the entire worksheet regardless of used range.

To reset the usedrange via code see Debra Dalgleish's site.

http://www.contextures.on.ca/xlfaqApp.html#Unused

Gord Dibben MS Excel MVP

>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
[quoted text clipped - 6 lines]
>Thanks in advance,
>Shelton

Reply to this Message

shelfish - 21 Nov 2007 06:39 GMT

Thanks for the link, I appreciate it. But for the record, I just tried
it again on a fresh workbook and ctrl+a only selected the used range.
I'm using 2k3. It must be something in the settings.

Anyway, thanks.

Reply to this Message

ilia - 21 Nov 2007 14:39 GMT

Do it a couple of times. First it selects the region, if you have
several lists in your worksheet.

> Thanks for the link, I appreciate it. But for the record, I just tried
> it again on a fresh workbook and ctrl+a only selected the used range.
> I'm using 2k3. It must be something in the settings.
>
> Anyway, thanks.

Reply to this Message