Thread: Using VB Code to update one workbook with data from 4 diffferent workbooks.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] banderson@nwws.biz is offline
external usenet poster
  
Posts: 8
Default Using VB Code to update one workbook with data from 4 diffferent w
JLGWhiz,
I tried changing that statement but to no avail.
It still gives me only the first and last record in my folders.
But if I use the command of (xlDown).Offset(0,2)
it brings in all the files for me.
Strange.
Thanks for the help!!


JLGWhiz wrote:
I think that instead of this:

Basebook.Worksheets(1).Range("A1").End(xlColumns). Offset(0, 2)

I would use this:

Basebook.Worksheets(1).Range("A1").End(xlToRight). Offset(0, 2)

Reply With QuoteReply With Quote