I'm trying to link to a named range within a spreadsheet. the range is a non-contiguous group of columns. However when I try to link to it the range doesn't show in the available range box. If I select a contiguous range that shows and I can select it. I also tried coding it using transfer spreadsheet but I got an error saying couldn't find the object 'Name of My range' Is this supposed to happen or am I missing something?