Thread: DECLARE VARIABLES PROBLEM
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
michael.beckinsale michael.beckinsale is offline
external usenet poster
  
Posts: 274
Default DECLARE VARIABLES PROBLEM
Hi ytayta55,

Sorry typo in original reply:

For Each i = 1 to 231
Set FromWks = Workbooks("YTA" & i & ".xls").Worksheets("sheet1")
existing code<<<
Next i


Michael
Reply With QuoteReply With Quote