Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile Error: Method or data member not found
The references are the same, this problem has suddenly started. I hav tried creating new code within the file, macro's will record but when try to run them they fall over at the line Selection -- Nick ----------------------------------------------------------------------- Nick S's Profile: http://www.excelforum.com/member.php...fo&userid=1651 View this thread: http://www.excelforum.com/showthread.php?threadid=31367 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile Error: Method or data member not found
What sheet is active when the code runs?
On Tue, 16 Nov 2004 06:50:06 -0600, Nick S wrote: The references are the same, this problem has suddenly started. I have tried creating new code within the file, macro's will record but when I try to run them they fall over at the line Selection. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile Error: Method or data member not found
after the error, in the vbe, look in tools=references and see if any
references are marked if MISSING. If so, this is the source of your problem. You need to unselect or fix the reference. -- Regards, Tom Ogilvy "Nick S" wrote in message ... The references are the same, this problem has suddenly started. I have tried creating new code within the file, macro's will record but when I try to run them they fall over at the line Selection. -- Nick S ------------------------------------------------------------------------ Nick S's Profile: http://www.excelforum.com/member.php...o&userid=16512 View this thread: http://www.excelforum.com/showthread...hreadid=313676 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compile error: Method or data member not found | Excel Worksheet Functions | |||
Compile Error: Method or data member not found | Excel Programming | |||
Method or data member not found | Excel Programming | |||
Method of Data Member not found | Excel Programming | |||
Getting "compile error" "method or data member not found" on reinstall | Excel Programming |