ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Code window changes case and throws error (https://www.excelbanter.com/excel-programming/426305-code-window-changes-case-throws-error.html)

owlnevada

Code window changes case and throws error
 
Does anybody know why changing something in the code window automatically
changes the case on the first letter of a property? In the Page setup code,
the word application should be a capital letter when it runs OK. I've
changed something and don't know what it is and now where the word
application appears its switched to lower case and throws the error "Expected
function or variable". When I copy this code to a new workbook, it runs
fine. Is my code file corrupt and if so, what is the best way to get around
this?

owlnevada

Code window changes case and throws error
 

The "A" in Application changes to lowercase for some strange unknown reason
in these property settings under PageSetup. It throws the error mentioned in
my other post he

http://www.microsoft.com/communities...xp=&sloc=en-us

With ws.PageSetup
..LeftMargin = Application.InchesToPoints(0.5) 'only the 'A' changes to
lowercase

and then throws the error.


"owlnevada" wrote:

Does anybody know why changing something in the code window automatically
changes the case on the first letter of a property? In the Page setup code,
the word application should be a capital letter when it runs OK. I've
changed something and don't know what it is and now where the word
application appears its switched to lower case and throws the error "Expected
function or variable". When I copy this code to a new workbook, it runs
fine. Is my code file corrupt and if so, what is the best way to get around
this?



All times are GMT +1. The time now is 10:34 AM.

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