Recording Macro Error Message

M

MWS-C360

While recording the macro, I access the cell I need the formula in and write
the formula. After writing the formula and hitting ENTER, I receive a
microsoft GUI with "Unable To Record", and ackknowledge the GUI by hitting
OK. The forluma is written to the cell - all even has the desired
result/calculation.

When I access the code, the navigation within the worksheet is listed in the
code, but the furmula is not listed.

I tried exiting the file and trying a second time, yet the same results. How
do I "reset" the macro recorder to again begin to record all aspects of a
macro recording?

Any and All Help is Appreciated - Thank You
 
R

Ryan H

Look for the Stop Macro button right where you clicked the Record button.
This will reset the macro.

If you continue to get the error then skip the part that causes the error
and where you want to enter a formula use this line of code instead of using
the recorder.

Sheets("Sheet1").Range("A1").Formula = "=SUM(A1:A10)"

I assumed Sheet1 and cell A1 and the SUM formula, but you can tweak it to
fit your application. Hope this helps! If so, let me know, click "YES"
below.
 

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

Top