Thread: pick last item from a (variable) range
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jeff.j.griffith@gmail.com is offline
external usenet poster
  
Posts: 22
Default pick last item from a (variable) range

Gert wrote:
Hi all,

Is there a formula to pick the last item out of a (variable) range

thanks in advance
Gert

How about this:

x(x.Rows.Count, x.Columns.Count).Value

where x is your range?

Reply With QuoteReply With Quote