Microsoft Office Questions? Ask a IT Expert for Support ASAP
Instruction is ActiveSheet.paste
Sorry I'm having a problem updating the macro. Patience
When I display the macro it now does not give me an update button. Am I missing something?
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.
let me resend the file
the xcell file is blue and white quota
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.
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
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.
Sorry, same error Run-time error 1004
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?
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.
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?
I don't see a developer tab. Is it on the home tab?
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?
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
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
Code 951650 wikisend
the name of the macro is macro4.
By the way I ran the macro after selecting record and it worked
Sorry I sent the wrong file
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.
I get 'Create table" box with question Where is the data for your table?
'=$N$7' is in the name box
I get the 'create table' box, question Where is the data and =$A$:$R$51 in the name box
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
I thank you for a good try. I will let you know what the fix is if I can get one. Thanks again.
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.
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.
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,
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.
I would like to cancel this question and rephrase the question.
Need to rephrase question and find new expert. OK