Hi everybody
I have a little problem. I have a macro which copies data in a colum
to a new sheet. This column contains a lot of cells with 0 as entry. I
order to calculate a correct average I remove all the 0 values and the
use "average". Now I need to find the first and last cells in th
column where there is data inorder to correspond to these rows. Can an
one help med pls?

Regards
Jona

--
joh
-----------------------------------------------------------------------
joho's Profile: http://www.excelforum.com/member.php...fo&userid=2698
View this thread: http://www.excelforum.com/showthread.php?threadid=40206