ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Compile Error: Method or data member not found (https://www.excelbanter.com/excel-programming/316951-compile-error-method-data-member-not-found.html)

Nick S[_3_]

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


Myrna Larson

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.



Tom Ogilvy

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





All times are GMT +1. The time now is 07:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com