[SOLVED] from ranges tables ???

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" <marinalimeiraa@yahoo.com.br> wrote in message
news:OHt7Yh1HGHA.648@TK2MSFTNGP14.phx.gbl...
> 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
news:eoFmkW4HGHA.528@TK2MSFTNGP12.phx.gbl...
> 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" <marinalimeiraa@yahoo.com.br> wrote in message
> news:OHt7Yh1HGHA.648@TK2MSFTNGP14.phx.gbl...
>> 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),CountA(Sheet1!$1:$1))

--
Regards,
Tom Ogilvy


"Marina Limeira" <marinalimeiraa@yahoo.com.br> wrote in message
news:On5y35%23HGHA.3000@TK2MSFTNGP14.phx.gbl...
> 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
> news:eoFmkW4HGHA.528@TK2MSFTNGP12.phx.gbl...
> > 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" <marinalimeiraa@yahoo.com.br> wrote in message
> > news:OHt7Yh1HGHA.648@TK2MSFTNGP14.phx.gbl...
> >> 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
> >>
> >>
> >
> >
>
>