View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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