You can always make a UDF volatile.

However, if you are using the function in the worksheet, the analysis
toolpak already offers a weeknum function - although, again, look at Chip
Pearson's page on week numbers.

--
Regards,
Tom Ogilvy

"Pokey*" wrote in message
...
Regarding the second question, are there Private Subs
that can be programmed for a specific cell or change in a
specific cell, i.e., if A1 changes, run that macro?


-----Original Message-----
Is there a way to format the worksheet so if I type 10
numbers in A1, that it automatically tabs over to C1?
And then repeat the process on the next row within a
certain range?

Also, can you find the Week of a certain date with
simple
code? I have a complex formula that works, but isn't
there a way similar to Month(Date)?

Thanks again!
.