ps: not sure if this part is true: Sheet1!R1:R65536
maybe Sheet1!C1:C256 or Sheet1'!R1C1:R65536C256