View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
clara clara is offline
external usenet poster
 
Posts: 252
Default Is it possible to remove the Select method in this case?

Hi all,

this code is from Stephen Bullen's book,

Range("A1").Select
lRealLastRow = Cells.Find("*", Range("A1"), xlFormulas, , xlByRows, _
xlPrevious).row
I'd like to know can we use other statement instead of range("A1").Select

Clara
--
thank you so much for your help