Andrew Price
Member
Can anyone help with the group function in excel?
The group function has 4 parameters start, end, by, matrix. I can initiate a selection of a group using the following code:
CHWORKSHEET:Range("A2:H" + string(vrow + 3)):Group(
CHWORKSHEET:Range("B2:B" + string(vrow + 3)),,,).
My problem is however, that I can't get the last 3 parameters to work. The second I try to fill out one of the other parameters I recieve invalid range messages.
Can anyone provide me with an example? or explain why this happens?
Thanks
Andrew
The group function has 4 parameters start, end, by, matrix. I can initiate a selection of a group using the following code:
CHWORKSHEET:Range("A2:H" + string(vrow + 3)):Group(
CHWORKSHEET:Range("B2:B" + string(vrow + 3)),,,).
My problem is however, that I can't get the last 3 parameters to work. The second I try to fill out one of the other parameters I recieve invalid range messages.
Can anyone provide me with an example? or explain why this happens?
Thanks
Andrew