View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Quick Formula question..

On Mon, 20 Jun 2005 16:22:53 -0500, DejaVu
wrote:


Ron -
That makes more sense to me as well (putting everything into the code).
It makes it simpler for me to understand as well. Thanks for your help
on this. It worked perfectly. The only thing that I changed was:
Target.Clear
to
Target.ClearContents

This lets me keep the borders on the cell. Thanks again for for the
help!!

DejaVu


Thanks for the feedback. Glad we got it to work for you.


--ron