PC Review


Reply
Thread Tools Rate Thread

Code window changes case and throws error

 
 
owlnevada
Guest
Posts: n/a
 
      31st Mar 2009
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 With Quote
 
 
 
 
owlnevada
Guest
Posts: n/a
 
      31st Mar 2009

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 here:

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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
custom message form - view code throws error sd Microsoft Outlook Form Programming 0 8th Apr 2010 12:10 PM
2nd TRY: Up from 2003 to 2007; code now throws error creatingobject?? Ed from AZ Microsoft Excel Programming 4 21st May 2008 06:24 PM
VBA code executes fine, but compiler throws error. Huh? baobob@my-deja.com Microsoft Excel Programming 2 19th Jan 2008 07:48 AM
VBS Script and ClearContents -- Code Throws An Error =?Utf-8?B?Z2FyaWJhbGRp?= Microsoft Excel Programming 4 15th Nov 2007 03:45 AM
[Q] Save As throws type mismatch error in control's code? Jason Weiss Microsoft Excel Misc 1 16th Jul 2005 04:21 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:28 AM.