Compile Error: Method or data member not found

  • Thread starter Thread starter Nick S
  • Start date Start date
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
 
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).
 
You must log in or register to reply here.

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
Compile error 'Method or data member not found' when closing Excel 6
Issue with TextFrame2: Library not found 2
input numbers for code 3
Compile Error: Method or data member not found error 0

Back
Top