from ranges tables ???

[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

 

[Tom Ogilvy]

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

 

[Marina Limeira]

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]

insert=>Name=>Define

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

--
Regards,
Tom Ogilvy

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