How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Richard Your Own Question

Richard
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 16842
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

Running Microsoft Excell. Running old macro. When I email macro

Customer Question

Running Microsoft Excell. Running old macro. When I email macro to windows 8 user and try to run the macro I get a runtime error 1004.
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  Richard replied 1 year ago.
Thank you for your question, my name is Richard.

What is the exact line and the code in the macro you get the error on?

Thanks

Customer: replied 1 year ago.

ONE MOMENT

Expert:  Richard replied 1 year ago.
thanks
Customer: replied 1 year ago.

Instruction is ActiveSheet.paste

Expert:  Richard replied 1 year ago.
Make sure before it you have

sheets("Sheet2").activate

And not

sheets("Sheet2").select

Of course replace Sheet2 with your sheet name.

Can you check this please Guy?

Customer: replied 1 year ago.

Sorry I'm having a problem updating the macro. Patience

Expert:  Richard replied 1 year ago.
no problem
Customer: replied 1 year ago.

When I display the macro it now does not give me an update button. Am I missing something?

Expert:  Richard replied 1 year ago.
You just edit the text in the Macro and save it Guy

You do not click a button to update a macro.

Press ALT+F11 to view it please.

Customer: replied 1 year ago.

I don't see the sheets("sheet2").select instruction. Could I mail you the macro so you can look at it? It's not that large. I am able to update the code now. I had to activeat macros as they had been shut down. I could pay extra for your help.

Expert:  Richard replied 1 year ago.
you can upload it guy

- Click the following link: http://www.wikisend.com
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"

Customer: replied 1 year ago.


514762

Expert:  Richard replied 1 year ago.
where exactly is the code Guy that has the problem?
Customer: replied 1 year ago.


let me resend the file

Expert:  Richard replied 1 year ago.
ok...
Customer: replied 1 year ago.


the xcell file is blue and white quota


 


wike 134083

Expert:  Richard replied 1 year ago.
the file does not exist on the site.

And can you answer ym question regarding where the code actually is?
Customer: replied 1 year ago.


Hmm. I uploaded the file to wikisend twice and got the numbers. The file is only 95kb and is an xl file. The code is located in an XL file on my computer.


 


Recommendation?

Expert:  Richard replied 1 year ago.
I just need you to tell me where the code is on the file you already uploaded.
Customer: replied 1 year ago.

The code is part of the file. When you open the file with xcell it will give you a matrix. You may have to enable macros next then go to view tab and then macros on the right of the drop down

Expert:  Richard replied 1 year ago.
yes I know, but where is the line of code that is failing, where in the excel file, in which module, Marco.

Customer: replied 1 year ago.


The instruction is about half way down the macro it is the only ActiveSheet.Paste instruction.


 


It comes after the comment


 


'Paste the old cell value D to G in new.....


 


When I run the macro "CTRL T" I get the error and it turns on the debugger to this ActiveSheet.Paste instruction.

Expert:  Richard replied 1 year ago.
Can you use this please

http://wikisend.com/download/164458/blue&white quota sheet.xls

Let me know the results please
Customer: replied 1 year ago.

Sorry, same error Run-time error 1004

Expert:  Richard replied 1 year ago.
Run this version Guy and tell me exactly which line it is failing on please.

http://wikisend.com/download/751364/blue&white quota sheet.xls

Customer: replied 1 year ago.

Sorry but now I get a question asking where the data is.


 


I have to go now and will be back later or tomorrow, what is good for you?

Expert:  Richard replied 1 year ago.
ok, that does mean it works, so it is an issue with the logic in the Macro (not finding data).

Tomorrow is ok.
Customer: replied 1 year ago.


Richie:


 


This macro has worked for years on older PCs. The problem is with the newer operating systems. If you want to test; just put a number in the 'todays round' for any golfer and 'CTRL T' to run. I question the logic error as we have used the macro for over 12 years. Something changed in the newer OS or excel.


 


If you can't find the bug I will pay you anyway and try someone else.

Expert:  Richard replied 1 year ago.
Can you do this.

On that computer, record a macro to copy and paste.

then use this code over your existing code Guy.

Let me know the results please
Customer: replied 1 year ago.


You will have to give me more instructions as I don't know how to record a macro to copy and paste. Do you want me to right click on the entire macro, copy it and then paste it back?

Expert:  Richard replied 1 year ago.
To record a Macro, on the Developer Tab in Excel, click Record Macro in the top left.

Then with your mouse, like normal, do a copy and paste.

Once done, Stop the Macro, and review the code Guy in the editor (where you see all your code)
Customer: replied 1 year ago.

I don't see a developer tab. Is it on the home tab?

Expert:  Richard replied 1 year ago.
You will have it hidden then.

Can you unhide it this way

http://msdn.microsoft.com/en-us/library/vstudio/bb608625.aspx

Customer: replied 1 year ago.


Problem! I'm running excel 2007 and it doesn't have a FILE tab. The microsoft instructions include excel 2010 and newer. Do I need to get newer software?

Customer: replied 1 year ago.


OK I have the developer tab and I recorded the macro but what do I copy and paste to? I looked at the macro 'golf' and I'm lost with what to do next

Expert:  Richard replied 1 year ago.
put the code here it gave you when recording please
Customer: replied 1 year ago.


When I press the record macro it gives me a box that shows the macro name 'macro3' and the place to store 'this workbook'


 


It doesn't give me a code

Expert:  Richard replied 1 year ago.
Can you save this file and upload it please

I will get the code.

Customer: replied 1 year ago.

Code 951650 wikisend


 


the name of the macro is macro4.


 


By the way I ran the macro after selecting record and it worked

Expert:  Richard replied 1 year ago.
It tells me the file does not exist

Can you upload it again please?

Customer: replied 1 year ago.


572590

Expert:  Richard replied 1 year ago.
Guy, none of the changes I have done for you are in this file
Customer: replied 1 year ago.


Sorry I sent the wrong file

Customer: replied 1 year ago.


Try 184636

Expert:  Richard replied 1 year ago.
It is the exact code as what we recorded.

But the recorded Macro does not error on the problem computer correct?

Customer: replied 1 year ago.

Well I'm not sure. Do I press record macro then run it and then end record and then send it?


 


I get the same error on the computer run time 1004.

Customer: replied 1 year ago.


I get 'Create table" box with question Where is the data for your table?


'=$N$7' is in the name box

Expert:  Richard replied 1 year ago.
Can you download and run this version please

http://wikisend.com/download/466172/blue&white quota sheet.xlsm

Customer: replied 1 year ago.

I get the 'create table' box, question Where is the data and =$A$:$R$51 in the name box

Expert:  Richard replied 1 year ago.
For me I do not get this..

Are you getting this on all computers?
Customer: replied 1 year ago.


I got that error on a laptop running Vista.


On my desktop running Windows 7 i get Visual Basic error 438


 


Object doesn't support theis property or methodI press debug and it takes me to macro instruction


 


range=(previous_scores_cells).add

Expert:  Richard replied 1 year ago.
ok, I really am not sure Guy, what the issue is.

It runs ok here.

I am sorry but I will have to opt out for another expert that may have new ideas.

Customer: replied 1 year ago.


Agree.


 


I thank you for a good try. I will let you know what the fix is if I can get one. Thanks again.

Customer: replied 1 year ago.
Relist: Inaccurate answer.
Need another excel macro expert
Expert:  Rachel-Mod replied 1 year ago.

Hello,

I’m Rachel, and I’m moderator for this topic. It seems the professional has left this conversation. This happens occasionally, and it's usually because the professional thinks that someone else might be a better match for your question. I've been working hard to find a new professional to assist you right away, but sometimes finding the right professional can take a little longer than expected.

I was checking to see if you had already found your answer or if you still needing assistance from another one of the professionals?

Please let me know if you wish to continue waiting or if you would like for us to close your question.

Also remember that JustAnswer has a multitude of categories to help you with all your needs from Health, Pets, Computers, Taxes, Cars, Finance, Law, to Home Improvement, and more.


Thank you,

Rachel

Customer: replied 1 year ago.


I still need an answer. The last expert gave it a good try but I think we both got frustrated trying to resolve the problem.


 


Please find another expert to answer this question.

Expert:  Rachel-Mod replied 1 year ago.

Hello,

Thank you, XXXXX XXXXX continue to look for a professional to assist you. Please let me know if I can be of any further assistance while you wait.

Best,

Rachel

Expert:  Rachel-Mod replied 1 year ago.

Hello again,


We are still working with the professionals to find you the best possible match. I wanted to touch base to see if you still needed a professional’s assistance.


Please let me know if you would like to continue to wait or if you would like to cancel your question at this time. We sincerely XXXXX XXXXX the extended wait time.


Thank you,

Rachel

Customer: replied 1 year ago.

I would like to cancel this question and rephrase the question.

Customer: replied 1 year ago.


Need to rephrase question and find new expert. OK

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
< Last | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    301
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Computer Manager

    Satisfied Customers:

    274
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    125
    Trained in Microsoft Office from 2000 through to latest version 2010.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    124
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    97
    Bachelor's Degree in Information Technology, Microsoft Certified Professional
 
 
 

Related Microsoft Office Questions

Chat Now With A Microsoft Office Technician
Richard
Richard
Microsoft Office Technician
16842 Satisfied Customers
Over 15 year experience resolving Microsoft Office Issues