View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Sam Wilson Sam Wilson is offline
external usenet poster
 
Posts: 523
Default Excel IF/ELS to all Macro

If ucase(worksheets("DO NOT DELETE").range("e54").value) = "YES" then
Call tagright
else
Call tagrightno
end if

"Freddy" wrote:

I want to use a Macro to conditionally call 1 of 2 macros

I have a worksheet called "DO NOT DELETE" that has a cell (E54) with a YES
or NO in it.

If it is YES, I want to call a macro called tagright and if it is NO, I want
to call a macro called tagrightno

Any help would be greatly appreciated.