I am receiving the method range of object worksheet failed error on the line below:
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...