Dymanics ranges in excel

[riflemex]

Hi everyone .. i´m newbie in excel, and i can´t find a function t
create a dynamic range function to a table, so i can insert new rows o
it and take those rows and do something to it.

I hope somebody can help me, there´re only a problem, my excel is i
spanish, so english functions don´t work

Thanks everyone!!!

P.D. - Sorry about my poor english, im from mexic

 

[Kieran]

riflemex,

I have gotten lazy with dynamic ranges and now use this utility
http://www.rb-ad.dircon.co.uk/rob/excelvba/utils/index.htm to construct
them.

I hope it helps your problem.

 

[Arvi Laanemets]

Hi

With 5-column table having header row in row 1, and with column A as one for
checking:
=OFFSET($A$2,,,COUNTIF($A:$A,"<>")-1,5)

Dynamic range for column C, without header, and column A as one for
checking:
=OFFSET($C$1,,,COUNTIF($A:$A,"<>"),1)

 

[Dave Smith]

Check out this page:
http://www.ozgrid.com/Excel/DynamicRanges.htm