M
michael wolf
I have a worksheet with a lot of data and want to use a
macro to copy the data from one cell and paste it as the
title of a chart (also created by the macro). I want to
be able to use this macro for worksheets with different
data and have it copy the new data from the new
worksheet. As of now, the macro actually pastes the
number from the original worksheet in which I first
created the macro instead of copying the data from the new
worksheet. How can I have the macro remember the cell
location instead of the actual data in the cell when it is
first recorded?
macro to copy the data from one cell and paste it as the
title of a chart (also created by the macro). I want to
be able to use this macro for worksheets with different
data and have it copy the new data from the new
worksheet. As of now, the macro actually pastes the
number from the original worksheet in which I first
created the macro instead of copying the data from the new
worksheet. How can I have the macro remember the cell
location instead of the actual data in the cell when it is
first recorded?