Hi all,

Why would it be that the first statement works fine however the second statement that is directly below it in the sub does not? It will select the cell but not the range.

Note: DWI is dimensioned as a worksheet and I have used it multiple times and works fine. Days_In always has a numerical value assigned to it.

I get a "method range of object _worksheet failed" message.



        DWI.Cells(a, b).Select
        
        DWI.Range(Cells(a - 5, b), Cells(a + Days_In + 5, b + 4)).Select
any suggestions?

Cheers,
Marcus