Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
Im seeking some kind of help here Ive got a range of dates given by DATE function (01-16-2007 01-17-2007 01-18-2007, etc.), i've also formated the cells so to get only the name of the day (Mon-Tue-Wed, etc). But Now Im trying to get a macro to identify Weekends so to get an action done, lets say for example, to insert 3 rows after each Sunday. Obviously i cant program something like : If range ("x") = "Sunday" then.... Since those are real dates. Id appreciate any kind of help Thanx in advance Jepane |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Identifying textcolor | Excel Discussion (Misc queries) | |||
Identifying | Excel Discussion (Misc queries) | |||
Identifying #N/A cells | Excel Worksheet Functions | |||
vba, identifying a range | Excel Worksheet Functions | |||
Identifying links | Excel Discussion (Misc queries) |