hi,
My prblem is i have defined a range with offset.
But when i m going to use data validation with using offset and Indirect function both, then the defined range not works in validation in excel.
Regards,
Prabira
hi,
My prblem is i have defined a range with offset.
But when i m going to use data validation with using offset and Indirect function both, then the defined range not works in validation in excel.
Regards,
Prabira
Could you post your formula.
Some tips
http://www.contextures.com/xlNames01.html#Dynamic
If you are happy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks