Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Function in VBA???
Hello Everyone,
The book that I have is NOT very descriptive when it comes to time/date functions. When looking for a date using a regular formula, I can get the date by using: DAY(L2). What is the VBA equivalent to that??? I want to look at a cell and look at the day. If the date in lets say cell A1 is 10/04/04, then I want to insert a row to make it 10/01/04. Plus, I would like to insert more rows leading up to the date of 10/04/04. So, it would look like this: 10/01/04 This would be inserted by VBA 10/02/04 This would be inserted by VBA 10/03/04 This would be inserted by VBA 10/04/04 This was the original date in cell A1. Any help would be appreciated... mv |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Function in VBA???
Day(Range("A1").Value)
-- HTH RP "Michael Vaughan" wrote in message ... Hello Everyone, The book that I have is NOT very descriptive when it comes to time/date functions. When looking for a date using a regular formula, I can get the date by using: DAY(L2). What is the VBA equivalent to that??? I want to look at a cell and look at the day. If the date in lets say cell A1 is 10/04/04, then I want to insert a row to make it 10/01/04. Plus, I would like to insert more rows leading up to the date of 10/04/04. So, it would look like this: 10/01/04 This would be inserted by VBA 10/02/04 This would be inserted by VBA 10/03/04 This would be inserted by VBA 10/04/04 This was the original date in cell A1. Any help would be appreciated... mv |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Function in VBA???
Activecell.Resize(Day(ActiveCell-1),1).EntireRow.Insert
-- Regards, Tom Ogilvy "Michael Vaughan" wrote in message ... Hello Everyone, The book that I have is NOT very descriptive when it comes to time/date functions. When looking for a date using a regular formula, I can get the date by using: DAY(L2). What is the VBA equivalent to that??? I want to look at a cell and look at the day. If the date in lets say cell A1 is 10/04/04, then I want to insert a row to make it 10/01/04. Plus, I would like to insert more rows leading up to the date of 10/04/04. So, it would look like this: 10/01/04 This would be inserted by VBA 10/02/04 This would be inserted by VBA 10/03/04 This would be inserted by VBA 10/04/04 This was the original date in cell A1. Any help would be appreciated... mv |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Function in VBA???
Activecell.Resize(Day(ActiveCell-1),1).EntireRow.Insert
"Michael Vaughan" wrote in message ... Hello Everyone, The book that I have is NOT very descriptive when it comes to time/date functions. When looking for a date using a regular formula, I can get the date by using: DAY(L2). What is the VBA equivalent to that??? I want to look at a cell and look at the day. If the date in lets say cell A1 is 10/04/04, then I want to insert a row to make it 10/01/04. Plus, I would like to insert more rows leading up to the date of 10/04/04. So, it would look like this: 10/01/04 This would be inserted by VBA 10/02/04 This would be inserted by VBA 10/03/04 This would be inserted by VBA 10/04/04 This was the original date in cell A1. Any help would be appreciated... mv |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function to lookup date on tab in excel and populate date on calen | Excel Worksheet Functions | |||
Difference betwen Excel Date () Function and System Date | Excel Worksheet Functions | |||
MAX figure within a date range as a function of today()'s date | Excel Worksheet Functions | |||
Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions |