RE: Compile error: rows

[davidam]

RE: Compile error: rows

I recently posted the following and Jonmo1 was kind enough to reply. He suggested that I might hunt for a sub with the same name and rename this sub. I found that I needed to put w/b and w/s arguments in front of Rows.

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

Here is my question: I was using a sub from one workbook to hide rows on the active workbook ( I have a two screen setup) and I suspect that this was causing the problem. I have built a bunch of macros in one workbook which I use to protect/unprotect, format etc. the active(under construction) workbooks. Is this ill-advised?

 

[RoryA]

Re: Compile error: rows

The error would be if you have a sub or function called 'rows'. That would be ill-advised for the reason you have discovered.

 

[davidam]

Re: Compile error: rows

...but not likely to lead to corrupt files and such?

 

[RoryA]

Re: Compile error: rows

No, there is nothing wrong with it per se.

 

[Norie]

Re: Compile error: rows

One other reason, perhaps unlikely, would be that you have a variable called 'rows' - all lower case.

 

[davidam]

Re: Compile error: rows

Thanks to all!

 

[davidam]

Re: Compile error: rows

PS...I can hardly believe this, but I did in fact have a sub named 'rows'...thats the kind of ***t that happens when you are building these files.