from ranges tables ???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marina Limeira - 22 Jan 2006 13:38 GMT

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

Reply to this Message

Tom Ogilvy - 22 Jan 2006 18:56 GMT

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

Signature

Regards,
Tom Ogilvy

> how to use data to create charts and database funcions as =dbmax, etc.. from
> the a data in sheet1 variable ?
[quoted text clipped - 5 lines]
>
> Marina

Reply to this Message

Marina Limeira - 23 Jan 2006 07:30 GMT

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

> In VBA,
> Dim rng as Range
[quoted text clipped - 28 lines]
>>
>> Marina

Reply to this Message

Tom Ogilvy - 24 Jan 2006 02:23 GMT

insert=>Name=>Define

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

Signature

Regards,
Tom Ogilvy

> Thanks Tom
>
[quoted text clipped - 43 lines]
> >>
> >> Marina

Reply to this Message