Problem in making Excel do define name based on cell value

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Problem in making Excel do define name based on cell value

02-19-2023, 12:23 AM

soroush.kalantari soroush.kalantari is offline

Windows 10 Problem in making Excel do define name based on cell value

Office 2016

Competent Performer

Join Date: Jun 2021

Posts: 124

I have found the answer. The “ RefersToR1C1:= formulaname” should be replaced with RefersToR1C1:=”=” & formulaname

Tags

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:24 PM.