View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Philip[_2_] Philip[_2_] is offline
external usenet poster
 
Posts: 8
Default Copy a Range from each workbook - Ron de Bruin VBA - a problem

The man's a genius! Thanks, Ron, works great.

Philip

Ron de Bruin wrote:
Use this

basebook.Worksheets(1).Cells(rnum, "H").Resize(SourceRcount).Value =
mybook.Name