MrExcel Publishing
Your One Stop for Excel Tips & Solutions

A follow up intended for Dave Hawley. Just a detail...


Posted by Nona Sloven on April 28, 2001 6:55 AM

Dave:

Thank you for your valuable help in your previous follow up! As a response to my posting, which solution I include below, you provided a code that really helped me. I, however, would like to add a detail in order for my project to accomplish what I need. I just, one more time, want to know how to get my macro "Refresh" also to run when I clear an entry in range D7:I9 and not only when I enter data on these cells.

Thank you a lot Dave!

Nona

Dave


Posted by Dave Hawley on April 28, 2001 6:59 PM

Thank you for your valuable help in your previous follow up! As a response to my posting, which solution I include below, you provided a code that really helped me. I, however, would like to add a detail in order for my project to accomplish what I need. I just, one more time, want to know how to get my macro "Refresh" also to run when I clear an entry in range D7:I9 and not only when I enter data on these cells. Thank you a lot Dave! Nona


Hi Nona

Remove; If IsEmpty(Target) Then Exit Sub


Dave

OzGrid Business Applications