Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Macro's in Toolbar / Macro's list | Excel Discussion (Misc queries) | |||
Suggested new functionalities for Filters, Pivots and other issues | Excel Discussion (Misc queries) | |||
Suggested new functionalities for Filters, Pivots and other issues | Excel Discussion (Misc queries) | |||
how do I run excel 4.0 macros on excel 2000 | Excel Discussion (Misc queries) | |||
calling a series macros with a marco | Excel Discussion (Misc queries) |