How to group rows?

K

Khaki

Hi,
I would like to groups rows 10 to 20 into one group, how would I d
this using VBA?

I tried this
activeworksheet.Range("10","20").rows.group
but it doesn't work.

I recorded a macro to group and I get this
Selection.Rows.Group

I think am close, but not quite.

TIA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping Rows 1
Macro to Group andor Ungroup rows and/or columns 3
Rows Group -looping issue 5
Grouping Question; Redux 1
vba code to filter the data like a group with group header 5
Grouping Based on Indent 7
Grouping rows with the plus/minus icon in the first row 3
Grouping rows in Excel with the plus/minus icon in the first row 5

Top