![]() |
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? |
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