what i would like to do, is set the 2nd variable to a range so i could use
the offset function in a loop.
so, in the formula, it would use the range set by the variable the 1st time
through, then using the offset it would use that range in the formula. the
range is a single cell.

sorry for the additional post

--


Gary


"Gary Keramidas" wrote in message
...
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