Macro not working:

[Richard Halls]

The attached file has code that is not working.

 

[Monty]

Hello Richard.

Welcome to forum.

Could you please explain me more..What you are trying to do..

Thanks

 

[Richard Halls]

The attached file has the macro and the data that is supposed to copy from one sheet into the other.

 

[Nebu]

Hi:

Your attached sheet contains a recorded macro and is not coded properly, if you want a solution please explain what you want to achieve using the macro and attach the right work book with some dummy values.

Note: In your macro you have mentioned sheet name 'Mac Rslt' which is not present in the uploaded file.

Thanks

 

[Richard Halls]

I guess I sent the wrong file. The attached is the right one I hope.

 

[Nebu]

Hi:

No the attached is not the right one, you have attached the same file. Also please explain what you want to do with the file. In your code you are trying to copy a formula as well. I cannot see any formula in your file. Where are the range mentioned in this part code in the attached spreadsheet.

Range("A5").Select
    ActiveCell.FormulaR1C1 = _
        "    Worksheets(""Sheet1"").Range(""b19:d10"").Copy Worksheets(""Mac Rslt"").Range(""b3:d3"")"

Thanks

 

[Richard Halls]

Copy to Sheet1 from Sheet2: a2:c2 to Sheet1 e4:g4 & h4 sum

Copy to Sheet1 from Sheet2: d2:f2 to Sheet1 e5:g5 & h5 sum

In Sheet1 in e6, f6, g6 & h6 sum

 

[Richard Halls]

The last file I sent was corrupted I think. There are new instructions in Sheet1

 

[Monty]

Hello Richard.

Please find attached file for your question..
Please click on the Run button in Sheet2.

Hope this helps...Please let me know further development of the file...Happy to help you..Monty.

 

[Richard Halls]

Nothing happens. Maybe the code has to be in a module.

 

[Monty]

Hello Richard..

code is in the module and linked to button to click.

 

[Richard Halls]

I don't see a red button.

 

[Monty]

Hello Richard.

Screenshort for your reference.

Open the file and look for sheet 2.

Please Let me know..if you still don't find

 

[Richard Halls]

Attached is my screen shot. Maybe the file you have has some code that is different than mine. When you hit run does it copy the data?

 

[Richard Halls]

Mayge the problem is that I'm using Office 10

 

[Monty]

Hello Richard.

That should not be a problem...Iam using office 2013 should work in 2010 as well..Let me know what you see in Sheet 2...Both are using same file format that is .XLSM which is macro enabled file only...

 

[Richard Halls]

Sheet2

 

[Monty]

Richard...Am not really sure...why you are not able to see button..


Just say Alt +F8 to open macro window then click run...Check if macro is working then we can think about adding button to it.

Uploaded one more file...Please check at the same time.

 

[Richard Halls]

What happend when you Run. Do you get any results?

 

[Richard Halls]

I've run it many times.

 

[Monty]

Thank you for being on forum!!!!!!

 

[Richard Halls]

So you don't get any results and don't have a solution.

 

[Derek McGill]

So you don't get any results and don't have a solution.

The file and code from "Monty" works for me !

 

[Monty]

Hello Richard....

Your are welcome. ..Let me know any more questions on this..

Month.