Hello,
I have a range that varies in size (number of rows and columns) depending on hidden cells. I'd like to copy the range and paste this into a cell in another sheet. The only thing is I want to resize the selected and copied range and make it fit into the cell.
So if the range is A1:Z50 (again, some rows and some columns will be hidden), then I want to copy the selection and paste it into Sheet2 cell B2. I've already expanded B2 to a fixed column width and row height, so this is not changeable.
At the moment I'm doing this manually by pasting the selection into a textbox and resizing this. Is there code that can make this easier and automated?
Many thanks,
Allison
I have a range that varies in size (number of rows and columns) depending on hidden cells. I'd like to copy the range and paste this into a cell in another sheet. The only thing is I want to resize the selected and copied range and make it fit into the cell.
So if the range is A1:Z50 (again, some rows and some columns will be hidden), then I want to copy the selection and paste it into Sheet2 cell B2. I've already expanded B2 to a fixed column width and row height, so this is not changeable.
At the moment I'm doing this manually by pasting the selection into a textbox and resizing this. Is there code that can make this easier and automated?
Many thanks,
Allison