Yeah I'm doing it in code....here's a little more detail, basically I
have a vlookup that needs to look at a limited piece of a table array,
the limitation of rows is my Variable.
Sooooo in this piece of formula....

=vlookup(cell,$A$1:$A$50,.....

I need the 50 to be whatever is in row 1 of the active column, (which is
where my variable is)

I know I am sharing my headache with you by now....much appreciated.

-mike



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!