Auto change defined name ranges on Jan 1st annually

Auto change defined name ranges on Jan 1st annually

Post by MarathonMa » Sat, 24 Sep 2005 07:02:55

Hi there!

I have the defined cell ranges below, all in the same sheet calle
Daily Tracking.

I'm wondering if it's possible for these to be changed automatically a
follows on 1st Jan each year?.

CurYTD: Single cell Y375 to single cell Z375 in 2006 then AA375 in 200
and so on, by 1 cell each year thereafter.

PreYTD: Row from B375:X375 to B375:Y375 in 2006, then B375:Z375 in 200
adding 1 cell to the range each year thereafter.

Counter: Change the value in cell CG376 to 1.

I really hope you can help me out here

1. Risc PC Clock keeps jumping to Jan 1st / Jan 2nd 2008 at power up (sometimes)

2. Named ranges scope / workbook/worksheet level named ranges- change

I use worksheet level ranges extensively and I usually do it so that I can
use the exact same name on multiple sheets and then use similar code to act
on each sheet using the named range. If you have worksheet level range and
a workbook level range with the same name, the worksheet range will take
precidence. I'd try to print out the range name and the refers to address.
I'd be willing to bet that you have range names in the source workbook that
look like this:


instead of just


Barb Reinhardt

3. Named ranges scope / workbook/worksheet level named ranges- changes with variable use...

4. Define a range based on another named range

5. Copy Range and Assign a Defined Name to the Pasted Range

6. VBA defined named range not appearing in Names list...

7. define range using col and row names; not cell name

8. auto insert worksheet name in dynamic named range

9. Selecting a named range, the name of the named range is in a cell

10. Locating 1st blank cell in named range

11. Named Range COUNTA fails when 1st record deleted

12. set up auto e-address feature,ie type 1st few letters of name,

13. How do I change a range name back to the underlying data range?

14. named ranges - changing ranges with month selected

15. VB Code Naming a Range (range changes each time)