Using Filters in Macros
 

I can't seem to replicate the problem you are referring to, but a few
helpfull hints. Be sure that you include the selection of the copy from cell
in your recording of the macro, it the cell is on a different sheet, then
ensure you include the sheet selection as part of your macro.

In other words select another cell, start recording, then select the correct
sheet, correct cell, copy, select destination cell, paste, stop recording

"Plum" wrote:

I am recording a macro which copies a cell and then pastes it as a criteria
for an autofilter. However, the macro records the exact name of the cell
value I have pasted. I would like the macro to copy and paste whatever is in
that cell, not the exact name. Any ideas?