View only user selected cells

**WashCaps** · 08-31-2010, 10:02 PM

I'm at a loss and hope someone can help.

I'm looking for a Macro that will hide all columns and rows in a worksheet except for the user selected (highlighted) range of cells. I've only been able to find macros that hide rows/columns that contain cells that contain zeros. Is what I want to accomplish even possible?

Thanks in advance!!

**MarvinP** · 08-31-2010, 10:38 PM

Hi WashCaps,

Did you know you can click on a column Letter and then right click and select "Hide". This will hide the entire column. Same works with rows.

Was that what you were looking for?

**WashCaps** · 09-01-2010, 12:04 AM

Hi Marvin,

Yes, I am aware of clicking on a column letter or row number and then right click and select "Hide". The goal I am aiming for is to make the process quicker by means of clicking a button linked to a macro. The macro prompts the user to select the range of cells they want to keep visible then the macro hides all of the columns, rows or cells that are not highlighted/not user selected.

Don't know if you are aware that Excel 2007 has 1,048,576 max rows and 16,384 max columns. Those numbers make hiding columns and rows a tedious task everytime I want to display the content of my selected range of cells.

**Alf** · 09-01-2010, 01:41 AM

Could you use the "ScrollArea" property perhaps?

Please Login or Register  to view this content.

Beware this needs to be reset everytime you open the
workbook. Excel doesn't remember your settings from the last time
so you could put it in an "Auto_Open" sub.

Alf