table variable

[Marina Limeira]

how to use data to create charts and database funcions as =dbmax, etc.. from
the a data in sheet1 variable ?

Because the data is import and I not know the total lines from range of the
table...

send please suggestions


Marina

 

[Debra Dalgleish]

You can use a dynamic formula to define the range, and it will adjust
automatically if the number of rows changes. There are instructions here:

http://www.contextures.com/xlNames01.html