Finding a Time value
I have a macro that goes to a cell and sets a var to the cells value. This
value is a time such as 6:00, 8:00, 20:00, etc.
I then use the application goto reference:=Mon_times to select a set of
cells in a row. This set of cells starts with a value of 4:00 and ends with
a cell containging the value of 3:00. It's 24 cells with each cell containg
an hour value in a 24 hour clock.
When I attempt to issue a Cell.find(what:=start_time).activate I get an
error, "Run-time error '91':" Object vairable or with block variable not set.
But I set the variable to the value of a cell prior to making the goto call.
What am I missing herer?
Thanks in advance.
|