adding new sub call creates problems

[TedH]

I added a new sub to and now I'm getting a compile error.

This was working fine until I added "Cust_Rev1". I get an compile error saying "expected variable or procedure, not module".

Both are located in personal.xlsb. If I rem Cust_Rev1 out, I don't get a hiccup. (FWIW, I've been running "Cust_Rev1" on its own to debug it.)

Main Program

Please Login or Register  to view this content.

And this is "Cust_Rev1". I threw the first 6 lines in for a quik test of the main program function .

Please Login or Register  to view this content.

[Leith Ross]

Hello TedH,

You have named your code modules the same as the procedures within them. Your module is named "Cust_Rev1" and the macro is named "Cust_Rev1". Either rename the module or the macro. An alternative is to call the macro this way...

Please Login or Register  to view this content.

[TedH]

Thanks Leith. VBA makes me feel like a buffoon sometimes.

Ted