hi,

in my macro i need to find the last value in a column there are zero's that have to be ignored

for example

a1 = 5
a2 = 7
a3 = 0
a4 = 6

therefore last cell is A4.

This cell reference could vary depending on how much data in going into column a

i will copy from that last cell across to the column t

thanks

steve