View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas[_2_] Gary Keramidas[_2_] is offline
external usenet poster
 
Posts: 364
Default if and else question

when using and if and else routine, can more than 1 variable be set.

for example.

if x =1 then
ShtNm = "sheet1"
mName = "Jan"
elseif x =2 then
ShtNm = "Sheet2"
mName = "Feb"
endif

i think you get the idea. if so, how would i do it?

thanks
--


Gary