I was wondering how to get the actual address by applying the first solution by FDibbins, becaue if the data does not starts from the first row, the cell address refers to the position within the arrey. Today i find the solution by Ace_XL works exactly what i wished. That is awsome!!! Again, thanks both!