View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
CBrine[_4_] CBrine[_4_] is offline
external usenet poster
 
Posts: 11
Default method range failed

Try changing it to this.

Set rCtySts = wkshtSource.Range(wkshtsource.Cells(lStartRow, lColTop), wkshtSource.Cells(lRow,
lColTop + 1))


You don't have a fully qualified reference with without ID'ing the Worksheet.

HTH
Cal