Hope someone can help with this issue.

I have a macro that is adding a person to an indexed range. Everything is
successful in adding and redexing the Data range except....in the macro and
for this test excercise I have a copy and paste from another cell in the
worksheet of Dates the value of "1"into the Data range named Data. I have
even left a blank column inbetween the Data range and the row index for the
index formula [Tim Smith Example]. I was thinking that the blank column would
set up my dynamic range well but instead I am getting the results [2nd Tim
Smith Example]. Can anyone see what I am doing wrong? I assume it is
something in the formula that I do not understand. Thanks in advance.

46 Row
Tim Smith Index

0 1

=OFFSET(Dates!$E$3,0,0,COUNTA(Dates!$E:$E),COUNTA( Dates!$3:$3))

46 Row
Tim Smith Index

1 1 1 1 1 1

--
Message posted via http://www.officekb.com