Hi:
I've tried recording a macro where a selection of rows are grouped together and then hidden. Below is the VBA code:
Range("B18:B22").Select
Selection.Rows.Group
ExecuteExcel4Macro "SHOW.DETAIL(1,22,FALSE,,17)"
When it comes to this final line, I get this error:
Run-time error '1004'
You've entered too many arguments for this function.
Since I didn't type in this code (recorded by the macro) this is very surprising. Can anybody help?
Cheers
Yasir
I've tried recording a macro where a selection of rows are grouped together and then hidden. Below is the VBA code:
Range("B18:B22").Select
Selection.Rows.Group
ExecuteExcel4Macro "SHOW.DETAIL(1,22,FALSE,,17)"
When it comes to this final line, I get this error:
Run-time error '1004'
You've entered too many arguments for this function.
Since I didn't type in this code (recorded by the macro) this is very surprising. Can anybody help?
Cheers
Yasir