Johnpants
11-18-2005, 06:00 AM
Hi, I am using an autofilter to get a single row of data, I then want a button to run a macro that will copy the cell in column a that is showing, to a different cell.
I can get the majority of this working, I have the button and can paste the copied cell to where I want, but the problem I am having is getting the macro to copy the cell from the autofilter..
Can anybody help with this please?
Thanks.
I can get the majority of this working, I have the button and can paste the copied cell to where I want, but the problem I am having is getting the macro to copy the cell from the autofilter..
Can anybody help with this please?
Thanks.