Variable name question
See VBA help for DateSerial(year, month, day)
you really should have Date in the IF stement if you don't use serial datte
if Range("A20") = date("5/7/2009") then
I fyou are trying to add 7 days to a date then use "+" not "&". The
aphersand connects strings together and doesn't add numbers
"5/7/2009" & 7 gives you
"5/7/20097"
You want
Date("5/7/20097") + 7
"JTWarthogs" wrote:
I have some code as follows - how do I name the idate in the if statement?
In the case below I was trying to make sure that it would be 5/7/2009 on both
sides (A20 = 5/7/2009) so the if statement should work it does not read
("idate" & i) as = to idate7 - so how can I get the right side of the if
statement to come up with idate7, or idate8, etc? I will use the For Next
statement to get the i value (1 to 31) to change. Is it not the ("idate"& i)
that is wrong even trying ("idate" & "7") does not work but I don't know what
i am missing.
Set idate7 = ActiveSheet.Cells(20, 1)
Dim i As Integer
Let i = 7
If datecurrent = ("idate" & i) Then
|