Macro te expand/collapse range

**graiggoriz** · 06-11-2014, 06:13 AM

Hello,

I have a range tha I called "DETAIL" I need to expand/collapse groups with same macro button.

CAn you please help me? I found some info on expanding rows but not a range.

Thanks ,
Graig

**nathansav** · 06-11-2014, 06:42 AM

You could do something like this, i am not in excel so not tested

sub Collapse(r as excel.range)
if r.rows.count>1 then
   r.rows("2:" & r.rows.count).entirerow.hidden=true
end if
end sub

sub Expand(r as excel.range)
if r.rows.count>1 then
   r.rows("2:" & r.rows.count).entirerow.hidden=false
end if
end sub

**graiggoriz** · 06-11-2014, 07:47 AM

Thanks but I would need only one macro.

**nathansav** · 06-11-2014, 08:02 AM

Combine the 2 with an if statement and another argument to say which way then :o)

**graiggoriz** · 06-12-2014, 06:36 AM

I really have no clue how to do that though.. Can you help?

In fact if the range is not easy to expand and collapse, I could use the rows 126:442 instead of range..

Would appreciate your help on that.

Thanks,
Graig

Macro te expand/collapse range

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Macro te expand/collapse range

Re: Macro te expand/collapse range

Re: Macro te expand/collapse range

Re: Macro te expand/collapse range

Re: Macro te expand/collapse range

Thread Information

Users Browsing this Thread

Similar Threads

Expand / Collapse Groups via Macro

Expand/Collapse when clicked

Excel Macro to Collapse/Expand grouped rows and columns

Macro to Group/Ungroup a specific Table plus macro to expand/Collapse grouped table.

macro to expand and collapse a pivot field failing.

Bookmarks

Bookmarks

Posting Permissions