hiding most of the rows in a sheet

cheveley

Active Member
Joined
Sep 24, 2002
Messages
273
I am trying to hide most of the rows in a sheet but when I attempt to do so I get the following errror message "cannot shift object off sheet".

Can anyone give me a pointer to correct this.

Thanks.
 
You can also:

1. Click the draw button to reveal the draw toolbar
2. Click the arrow (mouse-pointer) icon
3. Draw an imaginary square around where you think the image is
4. Release the mouse and press the Delete key.
 
Upvote 0

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
cheveley said:
thanks for the code but I would not even be sure where to stick it, in module 1 in VB?
yes just paste in a "normal" module
then from your menu tools / macro / macros ==> choose (from list): run

nbrcrunch,
sometimes it's difficult to convert myself from VBA to manual work :)
thanks for this simple method
 
Upvote 0

Forum statistics

Threads
1,215,410
Messages
6,124,756
Members
449,187
Latest member
hermansoa

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top