Thread: Jarek, almost there...
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default Jarek, almost there...
you're right Rick

thks

and in case UsedRange does not include xlLastCell could we try

For Each Cell In
ActiveSheet.Range(Cells(1,1),Cells(Activecell.Spec ialcells(xlLastCell).Row,Activecell.Specialcells(x lLastCell).Column)

?
Reply With QuoteReply With Quote