Compile error: rows

[davidam]

This is a strange one. I use the following

Rows("100:120").Hidden = True

or

Rows("100:120").EntireRow.Hidden = True

and VBA changes the Upper case R to a lower case r and gives this message:
Compile error:
Wrong number of arguments or invalid property assignment

It does not do it all of the time though...any thoughts?
Thanks
David

 

[Jonmo1]

First guess is that you have made some other macro or function called rows.
If so, rename that function..

 

[davidam]

As an afterthought, I tried adding the w/b and w/s info in front and that does seem to have worked:
ie:

Workbook("Book1.xls").Worksheets("Sheet1").Rows("100:120").Hidden = True