dbx file duplicates QUESTION I combined a lot of email messages from my inbox and sent box into anĪnyone know how to import to excel>remove the duplicates>export back to theġ.
> the grid is drawn in the Competition Grid Worksheet tab. > Competitions' based on the input, the appropriate grid macro is selected and > selected and I would like the a pop up screen to ask 'Number of > I setting up a Quiz Scoresheet that will run a macro to generate the Select Case InputBox('Number of competitions') Can a input prompt be added to excel spreadsheet for a value? This is a rough outline of what you want I think. Get N()? Can I employ wildcards in the search term?
How can I revised the search terms in the Find Method to ensure that I only The same thing happens with I search for the T()įunction as well. Works fine, except it also picks up any other function that ends with an N Refine search criteria for Find Method I am using the Find method to search for the N() function in a cell. Just being able to see the result which is how it is at the moment. If you click on cell A1 you can also see the formula i.e =A2*A3, rather than Possible that once the macro executes that the result is shown in cell A1 and I'm very new to writing Macro's in excel, what I want to know is If I haveĪ macro which tells excel that Cell A1 = Cell A2 * Cell A3.
