help needed

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

Hi,

I am trying to record a macro wherein I would just unprotect the sheet,
correct a small error in a formula and then protect the sheet.

I start recording, I unprotect the sheet, I correct the formula and the
moment I press ENTER i get an error "Unable To Record"

I have never seen this error before.

Please Help.
Gary
 
If the formula is longer than 255 characters, you may get that error.

It depends what change you want to make to the formula, but perhaps you
could make it without recording. For example, the following macro will
add +1 at the end of the existing formula:

Sub ChangeFormula()

With ActiveSheet.Range("D7")
.Formula = .Formula & "+1"
End With

End Sub
 

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

Macro Error "Unable to record" 1
Record time by formula 10
Protecting is NOT working right !!!!!!!!!!!!!! 6
Protecting sheet that has macro 5
Excel Protection 2
Unhide, Unprotect, Enter Password 2
using the =page! feature to transpose a row to column 0
Macros 1

Back
Top