Application or Object Defined Error TroubleShooting

[SBF12345]

Set arg1 = Workbooks("COMM_COMBINED_INDEPENDENTS.xls").ActiveSheet.Range(Cells(7, a), Cells(e, a))

I have been looking at this line for a while now and I can't seem to determine why I am receiving the error "Application Defined or Object Defined Error". I have all the variables on a watch list, nothing looks too funny.

Thanks,

 

[Norie]

Try this.

With Workbooks("COMM_COMBINED_INDEPENDENTS.xls").ActiveSheet
    Set arg1 = .Range(.Cells(7, a), .Cells(e, a))
End With

 

[SBF12345]

That did it! Thanks Norie