After you entered the range in the name box next to the formula bar, did the chosen range highlight?
Quote:
Just noticed that in the cell format option for date, only the date formats which are marked with '*' is applicable for auto jumping between months.
|
???????????