Dear friends..

i want your help regarding this subject.. can anyone help me?

actually, i have a big database in excel.. dont want to go last and first...
i want to know in certain cell (B1) which is the last entry had done in A:A.

thanks in advance


suresh tp

Hi Suresh,

See response in Programming

---
Regards,
Norman


"SURESH" <(E-Mail Removed)> wrote in message
news:uZca$(E-Mail Removed)...
> Dear friends..
>
> i want your help regarding this subject.. can anyone help me?
>
> actually, i have a big database in excel.. dont want to go last and
> first...
> i want to know in certain cell (B1) which is the last entry had done in
> A:A.
>
> thanks in advance
>
>
> suresh tp
>
>
>

Hi there,

xld has some excellent information relating to that on his site ..

http://www.xldynamic.com/source/xld.LastValue.html

HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.


"SURESH" <(E-Mail Removed)> wrote in message
news:uZca$(E-Mail Removed)...
> Dear friends..
>
> i want your help regarding this subject.. can anyone help me?
>
> actually, i have a big database in excel.. dont want to go last and
> first...
> i want to know in certain cell (B1) which is the last entry had done in
> A:A.
>
> thanks in advance
>
>
> suresh tp
>
>
>