copy a range including shapes
hello everybody, I have a small problem: I need to create a macro to copy a range from one sheet (sheet1!a13:FU45). and paste it to another sheet of the same workbook (same range). The problem is that the range I would like to copy contains shapes and I would like the shapes to be copied to. The amount of shapes varies so I never know how many and where they are in that range. Anybody can help me out with this?
Thank you all for any help
|