View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Soniya[_4_] Soniya[_4_] is offline
external usenet poster
 
Posts: 73
Default Name a Range based on Dates

Hello All,

I have dates starting from 01-03-2006 and till today

The dates keeps on adding but the same date is not repeated. Or say
even f it is repeated it is sorted according to date.

No how i can dynamically name the range based on month? for eg
01-03-2006 to 31-03-2006 named as RngMarch and 01-04-06 to 30-04-06 as
RngApr and so on..

Thanks