ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA - MS VB Compile Error (https://www.excelbanter.com/excel-programming/312416-vba-ms-vbulletin-compile-error.html)

jordanctc[_20_]

VBA - MS VB Compile Error
 

Thanks for the advise guys - I found the co-author inserted a macro lat
Friday after I left and I did not know it but he had named it "Format."
Thus the problem! A good lesson in naming conventions.

Jorda

--
jordanct
-----------------------------------------------------------------------
jordanctc's Profile: http://www.excelforum.com/member.php...nfo&userid=676
View this thread: http://www.excelforum.com/showthread.php?threadid=26617


Tom Ogilvy

VBA - MS VB Compile Error
 
That or through error or purpose defining Format as a variable was something
I considered, but it seems like such an error would occur on all computers
rather than some as you stated.

--
Regards,
Tom Ogilvy

"jordanctc" wrote in message
...

Thanks for the advise guys - I found the co-author inserted a macro late
Friday after I left and I did not know it but he had named it "Format."
Thus the problem! A good lesson in naming conventions.

Jordan


--
jordanctc
------------------------------------------------------------------------
jordanctc's Profile:

http://www.excelforum.com/member.php...fo&userid=6761
View this thread: http://www.excelforum.com/showthread...hreadid=266175




Myrna Larson

VBA - MS VB Compile Error
 
I'd call it a lesson in "reserved words" rather than "naming conventions" <g.

On Mon, 4 Oct 2004 14:19:12 -0500, jordanctc
wrote:


Thanks for the advise guys - I found the co-author inserted a macro late
Friday after I left and I did not know it but he had named it "Format."
Thus the problem! A good lesson in naming conventions.

Jordan




All times are GMT +1. The time now is 07:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com