Excel selecting a range of undefined length

I am kind of new to applescript and trying to convert a macro from
excel in applescript due to the lack of VBA support in Office 2008 Mac
edition.

To select a range using VBA I used to perform the following:

Ex:
Range("a3").Select
itemcount = Cells(Cells.Rows.Count,1).End(xlUp).Row
Range("e3:e" & itemcount).Select

Is this possible in applescript as the whole macro is dependent on the
itemcount variable.

Martin

I managed to figure out a solution using the following command:

set lastRowNum to first row index of (get end (cell 1 of row (count
rows)) direction toward the top)

then in all my references i used Range("A2"A"& lastRowNum) ... as
normal in VBA.

just incase anyone is interested.