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

In VBA,
Dim rng as Range
set rng = cells(rows.count,1).End(xlup)
msgbox "Value in last row, column A: " & rng.Value & _
vbNewLine & "Last Row is " & rng.row

in Formulas

=Indirect("A" & countA(A:A))

These only scratch the surface. There are many ways to determine the extent
of data depending on the conditions.
Also, if you use Data=Get External Data, the data are may be defined in a
named range (insert=Name=Define) so you could use that.

Just some additional information of interest not related to your question:
You might check out this site as well:

Orlando Magalhães Filho http://orlando.mvps.org


--
Regards,
Tom Ogilvy


"Marina Limeira" wrote in message
...
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

Thanks Tom

very good ideas

so, If I defined in a named range opcion... How define per example
formulas =SUM(cities)
VBA sum[cities]

but not imagine the size from external data?
how named this variable range named?

thanks again

Marina





"Tom Ogilvy" < escreveu na mensagem
...
In VBA,
Dim rng as Range
set rng = cells(rows.count,1).End(xlup)
msgbox "Value in last row, column A: " & rng.Value & _
vbNewLine & "Last Row is " & rng.row

in Formulas

=Indirect("A" & countA(A:A))

These only scratch the surface. There are many ways to determine the
extent
of data depending on the conditions.
Also, if you use Data=Get External Data, the data are may be defined in a
named range (insert=Name=Define) so you could use that.

Just some additional information of interest not related to your question:
You might check out this site as well:

Orlando Magalhães Filho http://orlando.mvps.org


--
Regards,
Tom Ogilvy


"Marina Limeira" wrote in message
...
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

insert=Name=Define

Name: list1
Refersto:
=Offset(Sheet1!$A$1,0,0,CountA(Sheet1!$A:$A),Count A(Sheet1!$1:$1))

--
Regards,
Tom Ogilvy


"Marina Limeira" wrote in message
...
Thanks Tom

very good ideas

so, If I defined in a named range opcion... How define per example
formulas =SUM(cities)
VBA sum[cities]

but not imagine the size from external data?
how named this variable range named?

thanks again

Marina





"Tom Ogilvy" < escreveu na mensagem
...
In VBA,
Dim rng as Range
set rng = cells(rows.count,1).End(xlup)
msgbox "Value in last row, column A: " & rng.Value & _
vbNewLine & "Last Row is " & rng.row

in Formulas

=Indirect("A" & countA(A:A))

These only scratch the surface. There are many ways to determine the
extent
of data depending on the conditions.
Also, if you use Data=Get External Data, the data are may be defined in
a
named range (insert=Name=Define) so you could use that.

Just some additional information of interest not related to your
question:
You might check out this site as well:

Orlando Magalhães Filho http://orlando.mvps.org


--
Regards,
Tom Ogilvy


"Marina Limeira" wrote in message
...
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