HI I have some data on on one sheet named Worksheets("Varieties") and on sheet1 I want to enter a search crieteria and copy the results form the data on the varieties sheet.
I recorded the following macro
This code works fine when I type in a search criteria and run the macro. However i then added the macro to a change event for a command button contained on sheet1 and i keep getting the subject of this query error come up.Please Login or Register to view this content.
Any ideas will be much appreicated
Please Login or Register to view this content.
Bookmarks