Compile Error: Method or data member not found

N

Nick S

Have been using a file for the last 6 months or so without any problems
However opened today ran a simple macro and got the above message.

Application.Goto Reference:="MondayDel1"
Selection.ClearContents

This is the simple coding that is causing the problem. I have recorde
the same procedure but when I run this new macro the same messag
appears. The problem seems to be with the Selection line. I dont thin
I've changed any settings but cant get my head around it.

Any help greatly appreciated.

Thanks

Nick
 
M

Mike Fogleman

Look carefully at the reference name. Does it match the name in the sheet?
At first glance this looks like MondayDE(eleven), but it is actually
MondayDel(one).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Runtime error 1004 Application-defined or object defined error" on data sort 0
Mac Excel compile error method or data member not found 0
Compile error: Method or data member not found 3
Compile error: Method or data member not found 2
input numbers for code 3
Issue with TextFrame2: Library not found 2
Compile Error: Method or data member not found 2
Compile error 'Method or data member not found' when closing Excel 6

Top