Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A question about Cells & finding the Week
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
A question about Cells & finding the Week
Dim TheDate As Date ' Declare variables.
Dim Msg TheDate = InputBox("Enter a date:") Msg = "Week: " & DatePart("ww", TheDate) MsgBox MsgBut there are varying definitions of the week number. You might want to look at Chip Pearson's sitehttp://www.cpearson.com/excel/weeknum.htm-- Regards,Tom Ogilvy "Pokey*" wrote in 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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
A question about Cells & finding the Week
Select the cells that you want to enter data into in the order you want to
move through them. Then use the tab key to go in that order. If you will do this often, once selected, then go to the name box and type in a name. then when you want to fill in these cells, go to the name box, hit the dropdown and select your named range. -- Regards, Tom Ogilvy "Pokey*" wrote in 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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
A question about Cells & finding the Week
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! . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
A question about Cells & finding the Week
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! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding the week of date | Excel Discussion (Misc queries) | |||
Finding the next dayof the week after a certain date. | Excel Worksheet Functions | |||
Finding Friday in week number | New Users to Excel | |||
Finding day of week in 2030 | Excel Worksheet Functions | |||
Finding week from date | Excel Programming |