Hi All,

I am trying to use row&col in a range. Code is as follows.
I get the errow application-defined or object-defined error

ShortRawMonFileName is correct and "Sheet1" is correct

Set source =
Workbooks(ShortRawMonFileName).Sheets("Sheet1").Ra nge(ActiveSheet.Cells(1,
1), ActiveSheet.Cells(16, 5))

I also tried

Set source = Workbooks(ShortRawMonFileName).Sheets("Sheet1").Ra nge(Cells(1,
1), Cells(16, 5))

Thanks
Chad