Module gets "Compile Error: Sub or Function not defined"

[perducci]

This code isn't working. I have it in a module. I get the "Compile Error: Sub or Function not defined"

Please Login or Register  to view this content.

Please Help!

Thank you

[WasWodge]

Try

Please Login or Register  to view this content.

It runs but whether it is what you want is another matter as I doubt the result in RES is what you desire

[ptm0412]

Hi perducci,
workbooks("P&L data macro.xls")
LastRow = Application.CountA(Range("A1:A10000"))

[WasWodge]

After reading the post from ptm01412 (I hadn't looked at your Workbook activate line) and with the comment I made at at the end of my last post below is what I suspect you are trying to do.

Please Login or Register  to view this content.

[perducci]

Thanks guys!

[perducci]

I had changed the name of the sub, I'm not sure if that had something to do with it. I re-started excel and used your code WasWodge and it worked! So again, thank you.