if and else question
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
|