Filling a column of cells outside a current region up till the last row in the region

I am writing a macro to fill column E in this set of data, up to the length of the column of data in A. So the macro should read up to the last row in column A and fill that many rows in column E. So for example when I run the macro, it will read 12 rows for column A and fill all 12 of column E's row with say Tiger.

Please Login or Register  to view this content.

Any help would be appreciated.

Try

Please Login or Register  to view this content.