Forum Discussion
Excel Name Definition using "indirect" formula within its Range target area
I'm not sure whay this doesn't work, but I suspect it has to do with the name also containing an INDIRECT
Dear Jan,
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.