Any Reason why my lastrow syntax works on one wookbook and not another

[Darthzo]

I am getting a object required error but when I use the same syntax changing the name of the work sheet in another workbook it works fine. Below is the syntax I am using to find the last row.

Please Login or Register  to view this content.

Other than the worksheet name everything is generic and should work for both sheets.

[mikeTRON]

Do they both have the tab called "Report" as that would cause issues?

[jaslake]

Hi Darthzo

What error are you getting?

[Darthzo]

I actually changed the worksheet just to test the command to Report(Mike). I am getting a object required error (jaslake).

[jaslake]

Hi Darthzo

Check for trailing (or leading) spaces in the Sheet Name..."Report" vs " Report" vs "Report "

[Darthzo]

I have attached the workbook. There are no spaces in the workbook name.

[shg]

It works fine for me, but it's an undeclared variable so there is no communication to the routine that needs it. Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

... and the routine to

Please Login or Register  to view this content.

[Darthzo]

I made the changes you suggested but come up with an error once I added the new sub(shg).

[shg]

What error, what line of code?

[Darthzo]

This line is highlighted red

Please Login or Register  to view this content.

[shg]

Oops:

Please Login or Register  to view this content.

As simple-minded as it is, though, I'd skip the function and put the code in line:

Please Login or Register  to view this content.

[Darthzo]

I am getting a Run-time error '424: when I run the last bit of code you posted. To make sure it's not my setting I will run this from another computer. Also are you able to run this in the attached workbook. I have used this syntax many time in the past and cannot see why it won't work just in this workbook for me.

[Darthzo]

Do you know what reference are standard for VBA I see a Personal one in my list this causes an error for me though when I enable it.

[Darthzo]

Not sure why but this one seems to work where the other does not. Is there something that special cells detects that the regular syntax does not?

Please Login or Register  to view this content.

[Izandol]

Do you use Excel 2003 or later version? If it is later it is better to use sheet object for Rows property also:

Please Login or Register  to view this content.

Also it is better to use Workbook object for the Worksheet.

[Darthzo]

I am using excel 2010. I actually found the issue. In the declaration I had Rows as a variant. This seem to cause all the issues. Changed the variable to Rws and works fine now.