Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help needed
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help needed
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 Gary wrote: 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 -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sports Comp Ladder tabulating help needed | Excel Worksheet Functions | |||
Macro help needed | Excel Discussion (Misc queries) | |||
Formula help needed | Excel Worksheet Functions | |||
"In Today's Dollars" help needed... | Excel Worksheet Functions | |||
VLOOKUP help needed! | Excel Worksheet Functions |