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!
.