swaink
Active Member
- Joined
- Feb 15, 2002
- Messages
- 432
Hi All
I wonder if I may ask for some help please.
I am working a very complex piece at the minute and am struggle with one area.
In column H5 down I have time values(HH:MM), in row I4:BO4 I again have time values(HH:MM)
My code looks for the time in Column H and finds it in row 4, all works well until I get to times after 22:00, where the code then jumps to the last column every time (05:30)
I have noticed that whilst the cells are formated as time(HH:MM) when i see the values in the code they appear as decimal values for example 0.9375
The code steps through each time in column H to match the time in the row and looks like this
mycolumn = Application.Match(ActiveCell.Value, Range("A4:BO4"), 1)
I've tried to DIM mycolumn as Integer and Double but no success
I would really appreciate some advise on this one
Regards
Kevin
I wonder if I may ask for some help please.
I am working a very complex piece at the minute and am struggle with one area.
In column H5 down I have time values(HH:MM), in row I4:BO4 I again have time values(HH:MM)
My code looks for the time in Column H and finds it in row 4, all works well until I get to times after 22:00, where the code then jumps to the last column every time (05:30)
I have noticed that whilst the cells are formated as time(HH:MM) when i see the values in the code they appear as decimal values for example 0.9375
The code steps through each time in column H to match the time in the row and looks like this
mycolumn = Application.Match(ActiveCell.Value, Range("A4:BO4"), 1)
I've tried to DIM mycolumn as Integer and Double but no success
I would really appreciate some advise on this one
Regards
Kevin