how to know where the last cell a value is in a column and transfer vales to an array

[LAazsx]

Hi, how do i code i macros that goes through a column, and transfers each value to an array but stops and selects the cell on the column right after the last cell which has a value?

[royUK]

Can you explain a little more fully

[LAazsx]

Lets say I have some values under column A namely 1 2 3 4 5. Each has it's own cell and there are no black cells in between. I want excel to first go through the column, transfer the value of the cells to an array and find out which row has no value and .select that cell.

[LAazsx]

sorry for the double post.. uhmm.. anyone have an idea? been at it for the whole day. i really have no clue

[DonkeyOte]

Perhaps you mean

Please Login or Register  to view this content.

(if you want the array as 1 dimensional apply a Transpose)