LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 23
Default Compile Error: Expected End Property

Has anyone any info on this error? I can't find anything.

My code worked when using XL97, but after our IT dept upgraded to XL2002 I
get this error. There is way too much code to post, but basically, the
workbook calls various workbooks to do calculations based on the data it
holds. This data is made into "value only" format and the vba code removed
so that it can be sent to clients.

For some reason the code breaks after removing the other workbooks code and
brings up one of the "sheet code" screens - even though there is no longer
any code there.

Can anyone see why this is happening or why it may have worked in 97 but not
2002?

many thanks
George
 
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
Compile Error: Wrong arguments or Invalid property Brent E Excel Discussion (Misc queries) 3 May 1st 07 07:11 PM
Micrsoft Visual Basic Compile error: Expected: end of statement IJ Excel Discussion (Misc queries) 5 October 23rd 06 12:08 AM
compile error: expected variable or function MMM Excel Discussion (Misc queries) 3 December 24th 04 03:11 PM
Runtime error 380: Could not set the List property. invalid property value of listbox jasgrand Excel Programming 0 October 6th 04 09:28 PM
expected sub, function, or property Josh[_3_] Excel Programming 3 July 17th 03 09:48 PM


All times are GMT +1. The time now is 02:11 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"