,I need to write a simple macro which checks value in a cell then, depending
on value returned, starts macro a or macro b. how do i do it.

Dim myCell as range
set mycell = workbooks("somebook.xls").worksheets("sheet999").r ange("a1")
or something like
set mycell = activesheet.range("a1")

if mycell.value = 8 then
call othermacronamehere
else
call adifferentmacrohere
end if



a m spock wrote:

,I need to write a simple macro which checks value in a cell then, depending
on value returned, starts macro a or macro b. how do i do it.

--

Dave Peterson

Many Thanks. Works like a charm!

"Dave Peterson" wrote:

Dim myCell as range
set mycell = workbooks("somebook.xls").worksheets("sheet999").r ange("a1")
or something like
set mycell = activesheet.range("a1")

if mycell.value = 8 then
call othermacronamehere
else
call adifferentmacrohere
end if



a m spock wrote:

,I need to write a simple macro which checks value in a cell then, depending
on value returned, starts macro a or macro b. how do i do it.

--

Dave Peterson