hy guys...
me again... hope i'm not anoying...
yesterday i was traying to copy same range of cells when a day was for example 30... and i managed that..
but know i was traying to complicate this hehe and say... that perform may copy code when the day in month is the last day and the clock is 23:55 ... is that posible ... i can get the code for the day but its stupid i needed to write for every month then this ... but wats with the time??
i have so:[VBA]If day(Range("j2")) = 30 And Month(Range("j2") 11 Then ... bla bla copy[/VBA]
but not every month has 30 days, and what0s with the time???
becouse i wanna mace it so that when the month is over the data should copy in a special sheet where the months are listed...
so if someone could help me to solve this please...
thanks alreday