View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
ytayta555 ytayta555 is offline
external usenet poster
 
Posts: 247
Default USEING IF FUNCTION TO COPY IN ANOTHER WORKBOOK

Please , one more question : how can I
do the query in column BD *in three steps :
(1)BD91:BD22000 , * (2) BD22001:BD44000 ,
(3step)BD44001:BD65536 , such as I
have 3 *myRng * ? (it's really my last
problem !)



I found the resolve for my problem :

With FromWks
Set myRng1 = .Range("BD91:BD22000")
End With ........


.... For Each myCell In myRng1.Cells


THANK YOU very much Dave ; I have no
words to thank you