View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] krcowen@aol.com is offline
external usenet poster
 
Posts: 109
Default Finding a Time value

you are missing the code. post your code and someone will probably
help you out.


On Feb 12, 2:51 pm, El Bee wrote:
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.