VBA Grouping Rows

[Littlemalky]

I have a report I do that has part numbers in column "J", then a break in rows and a group that is hidden below with more part numbers in it. I have the code that shows all data for column "J" so that it unhides the group and I can copy those part numbers. Is there any way to hide that group of rows if the amount of rows are always changing within that group?

It's the only group of rows in column "J", if that helps. Simply, "Visible = False" with the exact range isn't good enough for me at this point.

 

[GlennUK]

You can show or hide all existing groups by level. Is that what you want?

 

[Littlemalky]

Possibly, can you give me an example of code to use?

 

[GlennUK]

Maybe:

ActiveSheet.Outline.ShowLevels RowLevels:=1, ColumnLevels:=0

... I'm guessing, as I can't actually see your layout.

 

[Littlemalky]

Now is this suppose to show row 1, or what does the number signify exactly?

 

[GlennUK]

You said "then a break in rows and a group that is hidden below " ... that macro code makes groupings in Rows collapse to level 1.

 

[Littlemalky]

I get it!! Sorry, I never really grouped rows together before and didn't realize the outline part where it has the "1" and the "2". I just tested the code and it works perfectly. I really appreciate your help!