Why can't I record a macro to hide rows?

[Yasir]

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

 

[phillycarol]

I just recorded a similar event. Here's what I got and it works:

Rows("8:11").Select
Selection.EntireRow.Hidden = True