10-02-2020 08:16 AM
10-02-2020 07:34 PM
Dear Mr/Ms. Pieterse
Thanks, as told in my first posting, there us no error message & the same formula works
with Excel "Data Validation" Function as shown within the file linked here:
I don't think the INDIRECT argument currently evaluates to a valid cell reference. Try this:
- Copy the current formula from the name and paste it into any cell.
- Press F2 on that cell, highlight everything between the brackets () and press the F9 key once. Copy the resulting string
- press escape
- select another cell and press the = sign and paste. Now try to enter. If the address was valid you should not receive an error.
10-03-2020 04:47 AM
10-06-2020 12:27 AM
Thanks for your patients, Hopeful you've found out my purpose within the sample excel file I've provided earlier. That is: to have the function of :
"Changing target area without opening the "Name Definition" Editing Dialog Box" .
In other words, I would like only to key in only the starting Row number & the ending row number (of the target area) in any assigned 2 cells.
Thanking you in advance.