B
bev
Hi,
I'm hoping someone can help me with this. I'm trying to write a macro
that will select an entire worksheet (in Book1), open a new workbook
(Book2) and paste what I've copied. The problem is, there is a chart
object on the worksheet that reads from 2 columns in the worksheet.
When pasted in Book2, this chart still references the data from Book1.
I really want it to read from the same range of cells but in Book2
instead of Book1. Is this possible? The copied formulas in the
worksheet reference the cells in Book2 just fine.
Thanks,
bev
I'm hoping someone can help me with this. I'm trying to write a macro
that will select an entire worksheet (in Book1), open a new workbook
(Book2) and paste what I've copied. The problem is, there is a chart
object on the worksheet that reads from 2 columns in the worksheet.
When pasted in Book2, this chart still references the data from Book1.
I really want it to read from the same range of cells but in Book2
instead of Book1. Is this possible? The copied formulas in the
worksheet reference the cells in Book2 just fine.
Thanks,
bev