cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

converting a formula from one cell into its value into a different cell to avoid a circular

Mark_Shackelford
Copper Contributor

‎Nov 28 2022 06:32 AM

‎Nov 28 2022 06:32 AM

converting a formula from one cell into its value into a different cell to avoid a circular

Does anyone know the formula to accomplish this?

Labels:
780 Views
0 Likes
3 Replies
Reply
3 Replies
ecovonrein

‎Nov 28 2022 07:29 AM

‎Nov 28 2022 07:29 AM

Re: converting a formula from one cell into its value into a different cell to avoid a circular

There is no such formula. You can accomplish this via a SheetCalculate event sub in VBA. Here is a good primer: https://trumpexcel.com/vba-events/
0 Likes
Reply