Thread: Determine specific range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
VoTiger VoTiger is offline
external usenet poster
  
Posts: 6
Default Determine specific range

SrcRange=Mybook.Workshhets(ShtName(N)).Range(Range ("A2"),Range("A2").SpecialCells(xlLastCell))
Hi,
have you tried to make this ?

SrcRange =
MyBook.WorkSheets(ShtName(N)).Range("A2).Specialce lls(xlastcell)

Hope this will help you

Reply With QuoteReply With Quote