Define Name Range of non Blank Value

[saputroa272]

Halo
i just wondering how to define range name of non blank value in range A2:A30 for example
i've tried entering this one on refers to Control :=OFFSET(Sheet1!$A$2, 1, 0, COUNTA(Sheet1!$A:$A)-2,1)
any help will be appreciated
regard

[JohnTopley]

=OFFSET(Sheet1!$A$2, 0, 0, COUNTA(Sheet1!$A:$A)-2,1)

[saputroa272]

=OFFSET(Sheet1!$A$2, 0, 0, COUNTA(Sheet1!$A:$A)-2,1)

thanks for your reply john, it woked but only if the first cells (A2 and so on) are contain non blank value so if cell A5 is empty then values on cell A6,A7 an so on will not included