Finding a Time value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
you are missing the code. post your code and someone will probably
help you out.
 
Here's a portion of the code:

Application.Goto Reference:="Mon_times" ' cells S2:AP2
Application.FindFormat.NumberFormat = "h:mm;@"
Selection.Find(What:=start_time, LookIn:=xlValues).Select 'I get the
error here
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top