I am receiving the method range of object worksheet failed error on the line below:
G is a variant, PBK is "Set PBK = Workbooks("A_LA_CARTE.xls").Sheets("Sheet1")", and N is an integer variable
I am not sure why the range method used to select the range of cells is in conflict with the worksheet. Any ideas why there could be conflict here?
Code:
G() = PBK.Range(Cells(2, 1), Cells(N, 1))
G is a variant, PBK is "Set PBK = Workbooks("A_LA_CARTE.xls").Sheets("Sheet1")", and N is an integer variable
I am not sure why the range method used to select the range of cells is in conflict with the worksheet. Any ideas why there could be conflict here?