View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Maria[_7_] Maria[_7_] is offline
external usenet poster
 
Posts: 25
Default Find end of list - new problem

I'd like to. What does the command stand for? I don't
understand it properly. I've never heard
of "Usedrange" ... Maybe you could explain it whenever you
find some time.
Thanks a lot,

Maria


-----Original Message-----
Maria,

You could also try

With Activesheet
iLastRow =
..Cells(.Rows.Count,.Usedrange.Cells(1,1).Column) .End

(xlUp).Row
End With

--

HTH

RP
(remove nothere from the email address if mailing direct)