Thread: Workbook comparison results in subscript out of range error
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Charles Charles is offline
external usenet poster
  
Posts: 1
Default Workbook comparison results in subscript out of range error
whatisexcel,

In your test2 did you want

Workbooks("test2a.xls").Worksheets("Sheet1")

or

Workbooks("test2.xls").Worksheets("Sheet1")


Charle

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote