Macro within a macro
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
|