hi frns

I have a simple question, yet hard to answer for me :) ...

assume that we have a code sth like

sub countcells()

dim n as variant
dim counter as integer

Worksheets("data").Select

For Each n In ActiveSheet.Range("e:e")
If n.Value < 0 Then
counter = counter + 1
End If
Next n

End sub


as u can see we are counting the cells that are not equal to zero on
the column "e" here.

now i gotta use that counter to refer to a cell. it sud be sth like ex:
[a1:a+]

here plus sud be the counter that i define ....

what i wanna do is to copy the cells which have a value. But range may
differ everyday. So i sud count them.

i have searched for all kinds of references but cudn't find a
solution...

any help appreciated frnds ...

thx u all....