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?