|
|
#2
02-19-2023, 12:23 AM
|
|||
|
|||
I have found the answer. The “ RefersToR1C1:= formulaname” should be replaced with RefersToR1C1:=”=” & formulaname
|
| Tags |
| defined name |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Define range within word table between specific text instance and end of cell content
|
Thom.Simmo | Word VBA | 10 | 03-15-2022 05:28 PM |
| VBA - Printing form in excel based on cell value | blah blah blah | Excel Programming | 1 | 08-04-2016 11:22 AM |
| Hide a combo box (form control), based on a cell value - Excel 2010 | jaymudda | Excel Programming | 9 | 07-12-2015 10:59 AM |
| Can anyone here tweek this macro for renaming Excel files based on a cell's contents? | chrisd2000 | Excel Programming | 6 | 07-01-2014 01:53 PM |
|
Excel 2007, highlight entire row based on data found in one cell
|
MSofficeBLUE | Excel | 2 | 10-15-2013 09:51 PM |
Windows 10 
Office 2016
Threaded Mode