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

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

Your code is fine. To set a range declare a range object and set, e.g.

Dim rng As Range

Set rng = Worksheets(ShtNm).Range("A1")

--

HTH

RP
(remove nothere from the email address if mailing direct)


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

ok, thanks bob

--


Gary


"Bob Phillips" wrote in message
...
Your code is fine. To set a range declare a range object and set, e.g.

Dim rng As Range

Set rng = Worksheets(ShtNm).Range("A1")

--

HTH

RP
(remove nothere from the email address if mailing direct)


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