Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 44
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 44
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2nd TRY: Up from 2003 to 2007; code now throws error creatingobject?? Ed from AZ Excel Programming 4 May 21st 08 06:24 PM
VBA code executes fine, but compiler throws error. Huh? [email protected] Excel Programming 2 January 19th 08 07:48 AM
VBS Script and ClearContents -- Code Throws An Error garibaldi Excel Programming 4 November 15th 07 03:45 AM
[Q] Save As throws type mismatch error in control's code? Jason Weiss Excel Discussion (Misc queries) 1 July 16th 05 04:21 AM
Error in code re case construction PFL Excel Programming 2 February 6th 05 08:26 PM


All times are GMT +1. The time now is 03:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"