Named Ranges - Dynamically change?

[Redemptor]

If I have a named range, say from A1 - A200 called Transactions.
But then later I add more data, say to A250 is there an option to where the Named Range is automatically updated and I do not have to edit the named range to add the extra cells?

[StuartR]

You could use a table instead of a named range

[HansV]

StuartR's suggestion is excellent.

If you prefer to use a named range, you could define Transactions as follows:

=OFFSET($A$1, 0, 0, COUNTA($A:$A), 1)