wolf.stalker
11-12-2008, 06:29 AM
hi all. i am stuck.
i am reading in a value from sheet1.range("A1") and that value is "12/22/2008" (text...not number formatted).
my case statement is similar to this.
select case sheet1.range("A1")
case "12/01/2008" to "1/1/2009"
' do stuff
end select
when this runs, it will always skip my ranged date even though it falls in it. is this because we are comparing the input string to the range'd string?
i am just trying to understand why i am not able to use my case statement with a date range. any advice would be helpful. my next approach is going to be to maybe try converting to julian calander?
anyone have a good way of doing this?
i am reading in a value from sheet1.range("A1") and that value is "12/22/2008" (text...not number formatted).
my case statement is similar to this.
select case sheet1.range("A1")
case "12/01/2008" to "1/1/2009"
' do stuff
end select
when this runs, it will always skip my ranged date even though it falls in it. is this because we are comparing the input string to the range'd string?
i am just trying to understand why i am not able to use my case statement with a date range. any advice would be helpful. my next approach is going to be to maybe try converting to julian calander?
anyone have a good way of doing this?