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.


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.

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



" wrote:

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.