I have a filter macro that I would like to run if a user enters any data into a certain range of cells. Does anyone know if it is possbile to have a macro execute when data (any data) has been entered into a range of cells? Thanks!
Dan- thanks so much for your help. I tried using your code... substituting my data range and the name of my macro for YourMacroName, of course. When I enter data into my range I get a 'Compile Error - Ambiguous Name Detected: Worksheet_Change'. Can you tell me what to look for now? BTW, I'm using one other WorkSheet_Change Private Sub in the same worksheet and it works fine. Thanks!