Cannot Get Last Row in Column A

For some reason, the code thinks the last row on the sheet in Column A is row 1. I think I am seeing

Please Login or Register  to view this content.

and that has ALWAYS worked in the past to find the last row.

To test this, make a directory and copy _Test.xlsx into it as the only file. In Cost Report.xlsb, enter the path name to this directory in Cell B1 on the Control Panel Sheet.


The last row should be 266.

1st Shift (Wk 1) is Sheets(3) in Test file. Sheets(1) is Totals.
Check your reference in

Please Login or Register  to view this content.

It looks like this line in your code:

Please Login or Register  to view this content.

is referring to the"Totals" sheet not the "1st Shift (Wk 1)" sheet. Try:

Please Login or Register  to view this content.

That's why I posted here. The first two sheets were "hidden" because they were scrolled off the screen. I didn't even notice them on the VB Editor. I guess one cup of coffee was not enough this morning. .

I will adjust my code. What I need is the first sheet of this kind. I can figure that out.

Thanks for pointing out the very obvious to me